Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

dax help

hi,

 

   in my database i have some calculations are getting done on a view which is basically created on the grouping of a table..

 view def-  create view xyz as select a, b , c, d, e FROM table_data where date between '2020-10-31' and '2020-11-05'
                     group by a, b , c, d, e

Calculation - SUM(IF(c="delivered" AND date_diff(d ,e ,day)<4 AND date_diff(CURRENT_DATE(),e>3,1,0))  

                        result- 1500 

 

  but in my cube i have the same table (table_data) ..when i am trying to use same calculation here i am getting a different result...

Calculation - IF(table_data[c]="delivered" && DATEDIFF(table_date[e].[Date],table_data[d].[Date],DAY)<4 && DATEDIFF(table_data[e].[Date],TODAY(),DAY)>3 ,1,0)

                        result- 6300 

 

  Please need help to write this dax query.....only difference is database calculation is done on top of a view(where data is grouped) where cube is done a table

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    hi amit,

     

       it would be difficult for me to share the data..the question here is not on the data on the data model or dax query pattern...pls  let me know any dax pattern you want me to follow to write this query..