I've since worked out the issue. Thanks 🙂
Thank-you, Mynda. 🙂
Thank-you. Makes sense. One (hopefully last) question on this topic please, if the difference is a negative value, is there a way to indicate such...
Actually, it seems to work using the below: Last14answ = VAR CurrentDate = LASTDATE('DateTable'[Date]) VAR StartDate = CurrentDate - 14 VA...
Thanks, Mynda. This works great in Power Pivot for Excel. But returns blank in Power BI. Is there a different DAX format required for Power BI?...
Thanks, Mynda. Sorry, I was unclear. This is what I did in Power BI: divide by 86400 because this average answer time (raw data) is measured in...
Thanks, Mynda. This works great with sum aggregates. However, I'm struggling when the aggregate is average. The closest I got is with the belo...
Thanks, Mynda. I've attached the pivot table and the desired outcome (to be used in Power BI).
Thank-you. This is a tricky one! I have a few years of data, so added a year-week column to ensure each week is unique: YearWk = YEAR(DateTa...
Thank-you. This works. 🙂
Hi! I currently have a measure in PowerBI: Last Date = LASTDATE('RAW Data'[Date]) I'd like to concatenate this lastdate measure with...
Thanks, Mynda. The link above to "this post" is the same link as the "WEEKNUM function is explained here". I suspect this should not be the case? ...