Forum Discussion
Help please - datesinperiod question
Hi,
I have this formula:
it still gets the average for the last 12 because of the constant 12. Is there a way to "macro" the 12? Thanks!
Anonymous , if you selecting a date range from the slicer and you need that much data. you do not need datesinperiod
CALCULATE(average(Rental_Net)) , should do if date table is joined.
If you want a dynamic number in place of 12, use what if parameter https://docs.microsoft.com/en-us/power-bi/desktop-what-if
1 Reply
- amitchandak
Super User
Anonymous , if you selecting a date range from the slicer and you need that much data. you do not need datesinperiod
CALCULATE(average(Rental_Net)) , should do if date table is joined.
If you want a dynamic number in place of 12, use what if parameter https://docs.microsoft.com/en-us/power-bi/desktop-what-if