Forum Discussion
Solved
Previous Month without filter
Hi, I want to calculate the invoice count or average order value of the previous month. I got this working with either DATEADD() or PREVIOUSMONTH() but only when filtering my Power BI sheet to the c...
CountPreviousMonth = CALCULATE(COUNT(Invoices[InvNr]);PREVIOUSMONTH(DateTable[Date]))
sorry, there was a 'Date' to much :D
find correct formula above
Hi,
now it shows me the table as a result but the final measure is still blank :smileysad:
Many thanks!