Forum Discussion
PIYUSHPRAJAPATI
Resolver I
Resolver IRelated to DAX
Here, In the above attachment DATEMTD, DATEQTD,DATEYTD functions are working well. But when I on date hierarchy on the ORDERDATE following below snap shot then result of those columns has ch...
Hi PIYUSHPRAJAPATI ,
When you apply date hierarchy to ORDERDATE, it segments the data. For example, instead of treating all sales in May as a single continuous period, it now separates them into individual days within May.
The date hierarchy introduces granularity, which affects how these functions aggregate data. For example:
- In the non-hierarchical view, DATEMTD sums up sales for the entire month of May.
- In the hierarchical view, DATEMTD calculates sales for each individual day within May.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.