Forum Discussion
Previous Month not working
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Also, See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
Community ChampionPlease see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Also, See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
Greg,
Thank you for your response, It looks like my table is too complex for thease two functios (even with adding more selected values as filters)
I tested on very simple table 12 months 01/31/2020 - 12/31/2020 as EOM date and amount 100 - 1200 both Previousmonth and Dateadd functions works.
but did not work on my table. so for fast solution I duplicate the table with current period and previous period and attach
the curent period to the previous periods along with company department job and datekey and it works as expected.
I did not test the earlier function yet (when I have time I will).
Thanks again,
Oded Dror