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.
Hi All,
Apologies if this has been answered before, I have tried to google it but I'm not sure how to pose the question.
My issue is this:
Say I have several measures that need to do the same thing, on different data sources.
Example would be
Revenue = CALCULATE ( SUM ( column1 ) ,
DATESBETWEEN ( calendar , DATE ( 2019,01,01 ) , DATE ( 2019,02,01 )
))
What I would like to do is to create the DATESBETWEEN filter as it's own variable, seperate from the measure so that, in the eventuality that the DATESBETWEEN period needs changing, I would only need to change it once, not for every measure. Something like below is what I had in mind.
Period = DATESBETWEEN ( calendar , DATE ( 2019,01,01 ) , DATE ( 2019,02,01 ) )
Revenue = CALCULATE( SUM ( column1 ) , [Period] )
Many thanks,
Solved! Go to Solution.
Revenue = CALCULATE( SUM ( column1 ), TREATAS ( Period, 'Date'[Date] ) )
Regards,
Owen
Revenue = CALCULATE( SUM ( column1 ), TREATAS ( Period, 'Date'[Date] ) )
Regards,
Owen
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |