Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Sounds like the granularity level is different between your cube dimensions and your view groups. You did not specify which of the results you consider to be "correcter". Please provide sample data in usable format and show expected outcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |