Forum Discussion
Query regarding Date Hierarchy
Yes, that makes sense because it will assign the "+0" to all dates. One way you can overcome this is to apply a slicer so that it only shows the desired date range.
An alternative way would be to add Time Intelligence functions to your measure - although this is a bit more complex than a simple slicer.
I have two questions
1. Why will it assign +0 to all dates? Can u explain me the functionality pls.
2. Adding time intellignece function? Can u just show me a syntax as to how to achieve it in this dax
Sure!
- Based on your explanation and examples you can think of it as the following. Imagine you have the table where you don't change the blank to zero. It may look like this:
Jan and Feb have no values (they are blank/empty), so PowerBI will ignore them. However, once you change the blank to "0", it treats 0 as a "distinct value", rather than a blank. i.e. it is no longer empty. Does this make sense?Year Month Value 2022 Jan 2022 Feb 2022 Mar 123 2022 Apr 456 - There are many to pick from, and I would need to know what your desired outcome is. I'd recommend checking out this page to see which one works best for your use-case:
https://learn.microsoft.com/en-us/dax/time-intelligence-functions-dax
Thanku for your explanation. I still have queries. Can u pls check your chatbox or mail as I have send u a text.
Thx for your help but I'm still confused.
Hi Anonymous ,
Can you please tell me what else you are confused about?
For your first doubt, I think that even if you don't add 0, you can add index columns when you encounter duplicate values and it can help you avoid aggregation.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Based on your explanation and examples you can think of it as the following. Imagine you have the table where you don't change the blank to zero. It may look like this: