cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Compare previous and new sales in DirectQuery mode

Hi All,

 

I want to compare the sales result of the current month to the previous month. I found 3 simple DAX formula's.

All of them don't work in "DirectQuery mode". Function is not supported...

 

Prev. Month Sales = CALCULATE(SUM([Total Sales]),DATEADD([Date]),-1,MONTH))

Prev. Month Sales = CALCULATE(SUM([Total Sales]),PREVIOUSMONTH([Date])) 

Prev. Month Sales = CALCULATE(SUM([Total Sales]),PARALLELPERIOD([Date],-1,MONTH))

 

 

Is there a way to make this calculation in DirectQuery mode? Hope you can help me out with this one!

3 REPLIES 3
CheenuSing Super Contributor
Super Contributor

Re: Compare previous and new sales in DirectQuery mode

@canvasscompany

 

Check out the link

https://www.powerquery.training/portfolio/time-intelligence-with-power-query/

 

see if it helps.

 

Cheers

 

CheenuSing

 

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Microsoft v-yulgu-msft
Microsoft

Re: Compare previous and new sales in DirectQuery mode

Hi, @canvasscompany

 

To make DATEADD, PREVIOUSMONTH and PARALLELPERIOD function available in Directory Query mode, please

go to file -> options and settings -> options -> direct query ->"Allow unrestricted measures under direct query" .

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Datahungry Frequent Visitor
Frequent Visitor

Re: Compare previous and new sales in DirectQuery mode

Hi,

 

I realize this is an old one, but I just tried it having "Allow unrestricted measures under direct query" selected and it didn't work for me.

 

Am I missing something?

 

Thanks

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)