Forum Discussion
Comparing values from last period when date is always different using slicers before and after
Hello, I have 3 tables: 1) date table 2) holiday table that is linked to the date table 3) the value table. The value (SRT) table looks like this. The table with dates going back 3...
Hi Anonymous ,
Looking at your model there is no need to redo your measure. This is a questions about how you setup the table.
I have made the following changes:
- Hide the Date on the Sales Table
- Show the Date on the Date Table
- Used the Date from the Date table instead of the Holidays table
Result below (table on the rigth my table, on the left your table:
Hi Anonymous ,
Sample data without sensitive information and expected output would help tremendously.
Please see this post regarding: How-to-provide-sample-data-in-the-Power-BI-Forum
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.