I need help to correct the YTD totals
"Løn" means salary, so I am trying to calculate YTD Salary.
My measures are here below. The first measure "YTD Løn" is a bit different because I don't want it to show repeatedly in the matrix after the latest new value.
YTD Løn =
VAR _Today = TODAY()
RETURN
IF(MIN(dimDate[Date]) <= EOMONTH(_Today, -1), CALCULATE([Løn], DATESYTD(dimDate[Date])), BLANK())
YTD Løn budget = TOTALYTD([Løn budget],dimDate[Date])
YTD Løn Δ = IF(ISBLANK([YTD Løn]),BLANK(),[YTD Løn] - [YTD Løn budget])
@Jakob_BI Try this: Better Year to Date Total - Microsoft Power BI Community
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Fabric Community Update - January 2025
Find out what's new and trending in the Fabric community.
| User | Count |
|---|---|
| 131 | |
| 80 | |
| 53 | |
| 38 | |
| 35 |
