Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
77 | |
63 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |