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 simple matrix giving the value of a measure for this month and for last month. I want to show visually whether this has gone up, down or stayed the same. How can I do this?
I tried to create another measure doing one minus the last based on various of my period/date fields but it wouldn't recognise any of them as dates.
Difference = [Measure] - CALCULATE([Measure], PREVIOUSMONTH(MyTable[Date].[Date]))