Forum Discussion

Datahungry's avatar
Datahungry
Frequent Visitor
7 years ago
Solved

DIRECT QUERY equivalent to SAMEPERIODLASTYEAR

Hi everyone,   I'm using a SQL DB (DirectQuery  mode) as a datasource for my report. I have a DateTable and SalesTable. My goal is to have a report with: - 2 slicers: 1 for years; 1 for months ...
Need Help
  • Datahungry's avatar
    Datahungry
    7 years ago

    Thank you for the suggestion, I actually had enabled it already.

     

    I resorted to using a more complex DAX formula because I was trying to find a workaround for the "Power bi expects a contiguous selection" issue.

    However, it seems that, if I change the relationshipt between the Date dimention table and Sales from direction from "Both" to "Single" it works.

     

    Best regards

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Datahungry,

 

You could enable the highlighted option to use SAMEPERIODLASTYEAR() in Direct Query mode.

Best regards,

Yuliana Gu

Datahungry's avatar
Datahungry
Frequent Visitor
7 years ago

Thank you for the suggestion, I actually had enabled it already.

 

I resorted to using a more complex DAX formula because I was trying to find a workaround for the "Power bi expects a contiguous selection" issue.

However, it seems that, if I change the relationshipt between the Date dimention table and Sales from direction from "Both" to "Single" it works.

 

Best regards