Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I have a measure which sorts a list of values, takes 95% of the list and selects the max value.
It works when I filter on time, so it can sort the list on days, weeks months etc.
What I am trying to do now is take this measure and filter it to show from the start of the year, and create another measure which shows the same measure last year, in the same graph so I can create a line chart and show them beside each other.
I am new to dax, and I can't seem to make it work, I get blank values on my days.
This is what I have now:
VAL952018 = CALCULATE([VAL95Day];Filter(ALL(DimDate);DimDate[DateValue]<DimDate[FirstDayOfMonth]);DATESYTD(DimDate[DateValue]))
It runs, but I get no values.
EDIT:
I continued trying out different things, I now have two Measures but for another calculation that just counts the numbers of rows that has "true" in the "solved" column.
I have managed to create one that picks up the values from last year, and one that picks up the values from YTD. Problem is when I group them by month I get no values on the YTD measure.
_SolvedLastYear = IF(AND(FIRSTNONBLANK(DimDate[DateValue];1) >= DATE(YEAR(YEAR(TODAY())-1);1;1);FIRSTNONBLANK(DimDate[DateValue];1) < DATE(YEAR(TODAY());1;1));[_SolvedPercentage];BLANK())
_SolvedYTD = IF(FIRSTNONBLANK(DimDate[DateValue];1) >= DATE(YEAR(TODAY());1;1);[_SolvedPercentage];BLANK())
And if anyone knows it, how do I start my values from January?
Hi @AndersMadsen,
Can you share a dummy sample? It's hard to debug without data.
Best Regards,
Dale
*pushes to top due to updates*
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.