Hi all,
I'm sure that one of you can help me
I have a pivot table :
Columns : Year and Quarters
Rows : Customers Beginning of Qtr & Customers End of Qtr
Measures :
BOQ:=CALCULATE([EOQ]; PREVIOUSQUARTER(Calendar[FullDate]))
EOQ:=DISTINCTCOUNT ( Sales[Customer name] )
Everythings works perfectly fine until I add a slicer with Months and make a selection to have QTD info
Suddenly BOQ & EOQ are not right anymore
Thank you for your help
Arnaud
I'm sure that one of you can help me
I have a pivot table :
Columns : Year and Quarters
Rows : Customers Beginning of Qtr & Customers End of Qtr
Measures :
BOQ:=CALCULATE([EOQ]; PREVIOUSQUARTER(Calendar[FullDate]))
EOQ:=DISTINCTCOUNT ( Sales[Customer name] )
Everythings works perfectly fine until I add a slicer with Months and make a selection to have QTD info
Suddenly BOQ & EOQ are not right anymore
Thank you for your help
Arnaud
Last edited: