Forum Discussion
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 changed. Why we not working date hierarchy on the Time Intelliegence functions ?
3 Replies
- Idrissshatila
Super User
Please share sample data in a usable format (not screenshots) that fully addresses your issue or question.Avoid including sensitive info or unrelated content. Need help uploading data? Visit https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Show what you expect based on the provided data.
For faster answers, see https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M607150
PIYUSHPRAJAPATIThank You for feedback of post, to getting the fast reply from the community.
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.
