Forum Discussion
Helper IIIDivide this month data with last month data
You would need to create another Calendar table in order to relate the 2 tables.
Calendar Table = CALENDARAUTO()The key is the you need to the get the ID count of previous month:
Total Prev month= CALCULATE(COUNT(OLTP[ID]),PREVIOUSMONTH('Calendar Table'[Date]))Check the measures and relationships with my test file:
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rezaaditia
Try:
https://qiuyunus-my.sharepoint.com/:u:/g/personal/paul_qiuyunus_onmicrosoft_com/ESTzvGfxWBZPgUxU7B1MHJABThww631F3nv20JB_ajMPAQ?e=P7uutg
Basically other I used Date from the CalendarTable, created the Total of previous month.
Total Prev month= CALCULATE(COUNT(OLTP[ID]),PREVIOUSMONTH('Calendar Table'[Date]))
Then calcuate the percent with:
% = SUM('OS-OLAP'[OS])/[Total]
And finally put 'OS-OLAP'[OS], Total measure and % measure in the table.
Regards
Paul
Helper IIIHi Anonymous
Thank you, i think i can't open due the version on mine still June 2019. I already open ticket to IT to update my power bi.
Thanks a lot for your feedback, really appreciate it.