Forum Discussion
Query regarding Date Hierarchy
Hello All, I have a query. Pls help me out anyone. Whenever I am loading Year, Month (which are calculated columns) fields from Calendar table I am getting data exactly from the date/month fr...
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.