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.
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.
Helper IIIHi -
Thank you for your solution and sorry for late response, was on travel.
btw i am not able to open your file,
Thanks
Reza
rezaaditia
Try:
https://qiuyunus-my.sharepoint.com/:u:/g/personal/paul_qiuyunus_onmicrosoft_com/ESTzvGfxWBZPgUxU7B1MHJABThww631F3nv20JB_ajMPAQ?e=P7uutgBasically 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- rezaaditia
Hi 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.