01-10-2017 08:16 AM
I need a phormula that calculates a value of the previous month before the current one.
I don't want to use slicers to select the month. There has to be something 'invisible' for end user.
I have tried this: REVPAR previous month = CALCULATE(SUM('REVPAR/REVPAG'[Amount)/SUM('REVPAR/REVPAG'[Capacity]);FILTER(DimDate;DimDate[Month]=MONTH(TODAY())-1);FILTER(DimDate;DimDate[Year]=YEAR(TODAY())))
As you can see, it doesn't work because current month is Jan-2017 and the phormula refers to Dic-2017.
Thanks in advance,
01-30-2017 03:52 AM
I think if I use PreviusMonth i must select a month in slicer. This is not the thing I want to do.
I want to show previousmonth before current without select month in a slicer.
It must be dynamicilly, without user interaction.
Anyway, I have created a boolean column that indicates if sales date is in the previusmonth.
If I filter by true, It works.