Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to see my main values like turnover and sales with certain periods (custom) and visualize the difference between them.
I'm trying to use a compared time filter, but it resets directly when I change it slightly with values. I don't understand where I went wrong.
What i did:
1-) I created a new table
2-) I created a relationship
3-) then i sync my values with Dax
I can clearly see that the report is working, but when I try to pull data at different times, the data is reset.
Hi @hasaneyldrm to see any kind of previous values just use time intelligence functions in DAX, like MTD, YTD ...
some of examples on link . Hope this help
https://www.daxpatterns.com/standard-time-related-calculations/
Proud to be a Super User!
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |