Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
i'm fairly new to PowerBi.
On our dashboard we'd like to always show the second last month and this month data on a card each.
I understand for "last month" i could use filters. But for second last i have to use formulas.
Could you please state the formula necessary and as well where i can put in the formula?
Much appreciated, KR,
Nick
Solved! Go to Solution.
@Anonymous
For 2nd Last month ( I mean Previous month of Previous Month if I am Clear)
CALCULATE(Sum(the value column),DATEADD(DATEDIM[DATE],-2,MONTH)
This can get you the resutl
Please share your Kudoes and if you find this as solution please mark this as solution.
Also you can watch Videos at www.youtube.com/perepavijay
Proud to be a Super User!
Hi @Anonymous ,
Right click the table name and select create new measure.
Paste the formula here and modify the table or column name in the formula
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous https://www.youtube.com/watch?v=dLON3mj0los
Watch this Video to understand Time Intelligence Completely
Proud to be a Super User!
@Anonymous , With date table and time intelligence
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
this month =MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))
last MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
previous month value = CALCULATE(sum(''Table''[total hours value]),previousmonth('Date'[Date]))
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
last to last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-2,MONTH)))
previous month value = CALCULATE(sum(''Table''[total hours value]),previousmonth(dateadd('Date'[Date],-1,MONTH)))
@Anonymous
For 2nd Last month ( I mean Previous month of Previous Month if I am Clear)
CALCULATE(Sum(the value column),DATEADD(DATEDIM[DATE],-2,MONTH)
This can get you the resutl
Please share your Kudoes and if you find this as solution please mark this as solution.
Also you can watch Videos at www.youtube.com/perepavijay
Proud to be a Super User!
Hi Vijay, and where do i paste the formula to?
Hi @Anonymous ,
Right click the table name and select create new measure.
Paste the formula here and modify the table or column name in the formula
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |