Hi,
I got a Power BI report and I am trying to automate them.
It contains some measures which calculates the development of the last 2 years.
One of the Measure written like shown.
@Nanaki , if you want to display last year of selected value
a measure
last year =
year(maxx(allselected('Date'),'Date'[Date]) ) -1
also do not use .date . Please mark your date table as date table
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
I started with step one and marked my table as a date table.
I will continue with the other steps later, but by marking it I lost my hierarchy and now I cant even filter it with my old filter for the seperate year.
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
User | Count |
---|---|
339 | |
86 | |
63 | |
54 | |
50 |
User | Count |
---|---|
361 | |
128 | |
101 | |
98 | |
58 |