Forum Discussion

switchback5's avatar
switchback5
Frequent Visitor
6 years ago

How to filter DirectQuery for Same Day Last Year

I am using DirectQuery to connect to my Snowflake DWH.  I am trying to create a dashboard that has two very similar cards - both contain the sum of total revenue, one for yesterday's date and one for...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi switchback5 

's measure is greate. I build a table in SQL and connect to Power Bi by Direct Query, then test by his measure. I get the result.

Result:

Could you tell me if your problem has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.