Forum Discussion
Jakob_BI
Helper I
Helper IYTD calculation wrong totals
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])
1 Reply
- Greg_Deckler
Community Champion
