Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a transaction table that holds transactions to year 2020 (due to accruals) which is giving me problem when creating YTD formulas. My idea was to limit my calendar table to only this year (now it is MAX of posting date from the transaction table), but I don't want to this manually as it is easy to forget to update the year every year.
Do you have any suggestions on how to solve this? Any other solutions are of course welcome too.
Thank you.
Lisa
Solved! Go to Solution.
@LisaB how are you currently doing it?
you can set your report filter to only look at current year
drag the date in and set it to relative date filtering
Proud to be a Super User!
@LisaB how are you currently doing it?
you can set your report filter to only look at current year
drag the date in and set it to relative date filtering
Proud to be a Super User!
Hi,
That works, I like easy solutions. 🙂 Thank you!
Lisa
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |