Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have a scenerio where i need to calculate the total sum of a measure for the current quarter but the problem is there is an report level filter which is MONTH
So the requirement is when a user selects any month in the slicer the total sum would be the sum for the quarter to which the month falls to
Suppose the user has selected MAY as the month slicer,the measure would show the total sum for the particular quarter which is nothing but (APRIL,MAY and JUNE)
I tried using the below query but the data is returning each month data rather the quarter data.
IF(ISFILTERED('C&SB'[Month]),
CALCULATE(SUM('C&SB'[Actual]),DATESBETWEEN('C&SB'[Date],DATEVALUE(STARTOFQUARTER(ALLSELECTED('C&SB'[Date]))),DATEVALUE(ENDOFQUARTER(ALLSELECTED('C&SB'[Date]))))))
Help would be really appreciated
Regards
Prabin Nepak
Solved! Go to Solution.
Hi Prabin,
Filter the scope with calculating the quarter of the selected month from slicer like below:
Hi , both
I implemented this for current month calculation ,and it worked fine .However same i would like to implement for previous month , can anyone let me know how to use DAX formula for the same .
Currently i am using ,
Hi Prabin,
Filter the scope with calculating the quarter of the selected month from slicer like below:
Hi Anonymous,
Thank you!
I would like to ask if you know how I can add a filter for the year (based on a slicer) on this expression?
Hi , both
I implemented this for current month calculation ,and it worked fine .However same i would like to implement for previous month , can anyone let me know how to use DAX formula for the same .
Currently i am using ,
Hi Amit,
It was really helpful
Thanks
Prabin Nepak
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |