Related to DAX

[PIYUSHPRAJAPATI]

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 ?

[Anonymous]

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.

[Idrissshatila]

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-...

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/1447...

[PIYUSHPRAJAPATI]

Thank You for feedback of post, to getting the fast reply from the community.