Previous month column in Direct Query mode

[Anonymous]

Hi All,

I can able to create previous day value in import mode but i couldn't able to perform rankx operation in direct query mode.

How to get previous month value in another column in direct query mode?

Thanks

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

We can use EDATE function to work on it. Please refer to the formula as below.

Measure = var a = EDATE(MAX('Product'[SalesDate]),-1)
return
CALCULATE(SUM('Product'[Quantity]),FILTER(ALL('Product'),'Product'[SalesDate] = a))

[Anonymous]

Have you checked this:

go to file->options and settings -> options under direct query, select "allow unrestricted measures"

Please go through the link below for more information :

https://blog.crossjoin.co.uk/2017/05/09/dax-functions-directquery-and-unrestricted-measures/

You can also try ranking them in TOPN Visual level filters or in the SQL Query itself.

Thanks,

Nishanth.

[Anonymous]

Hi @Anonymous ,

That options is not showing up for me.

go to file->options and settings -> options under direct query, select "allow unrestricted measures"

Thanks