Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Team,
I have the date table and Amount from the sales table
When I select a date of let's say 15 April 2021 then I need that Column should show me Before 2 month Sales and After 2-month sales (i.e., 15 Feb to 15 April sales I need ) and 16 April to 15 June
If I select a Month instead of a date, let's say I selected July 2021 it then it should show me May-June and July-August sales.
Here is a measure expression that shows one way to do it. You can adapt it and use MAX('Date'[Date]) to get the Next Two Months measure.
Two Months Before =
VAR mindate =
MIN ( 'Date'[Date] )
RETURN
CALCULATE (
[Total Sales],
FILTER (
ALL ( 'Date' ),
'Date'[Date] >= EDATE ( mindate, -2 )
&& 'Date'[Date] <= mindate
)
)
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |