previousmonth not working when reordering datekey

[kamijaja]

Hi Power BI community, 

seems like I break previousmonth function or then any previous functions when I try to trick displaying months desc on a dashboard. 

for desc dates on dashboards we found this trick to add a new column desc = tab[date_key] * (-1) and order then datekey according to this new column. the problem is then those previousmonth etc. don't work anymore.

do you know then how to trick the dates to be displayed desc and that previous functions would not break?

Thanks!

[v-danhe-msft]

Hi @kamijaja,

Based on my test, it could work on my side:

Column = [Date key]*(-1)

Could you please offer me more information about your data structure if possible?

Regards,

Daniel He

[kamijaja]

I would like to calculate a value based on the previous month. I successfully used the previousmonth function in a measure. The problem with it, is that, whenever I sort date by descending order on a matrix visualization, then the previousmonth measure doesnt work at all.  I used this measure to create the date sort...  "Date_sort = tab[date_key] * (-1)". 

[v-danhe-msft]

Hi @kamijaja,

Could you please share some sample file to have a test if possible?

Regards,

Daniel He