The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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*