Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

SQL to DAX conversion

How to convert below SQL query to a DAX measure. The 'date' case structure should be dymanic to get last 4 months data.   select  mnth,M1_Ord,M2_Ord,M3_Ord,M4_Ord,Is_cons_flg,count(outlet_id)  out...
Need Help
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hi Anonymous ,

 

a 1:1 translation makes no sense in my opinion.

You can filter and transform the data with Power Query while importing data.

In the report you can then visualize the data in a matrix.

The last 4 months can be filtered using a relative date filter.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Its a live connection. Can't do any changes in Power query. Need a DAX measure for same.

    • mwegener's avatar
      mwegener
      Icon for Most Valuable Professional rankMost Valuable Professional
      5 years ago

      Hi Anonymous ,

       

      can you share a screenshot of the table from the Power BI model view?