Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 from which data is available in power bi. Pls find below screenshot where the minimum date is 2nd dec 2023.
But when I am using Year, Month as Date Hierarchy it shows me those dates as well which are not available in power bi. Pls see below screenshot.
Can anyone pls help me with the logic thats running behind this? I am getting confused.
Thanking you guys in advance for your help.
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!
Year | Month | Value |
2022 | Jan | |
2022 | Feb | |
2022 | Mar | 123 |
2022 | Apr | 456 |
Thx for your help but I'm still confused.
Hi @Sushain_Koul ,
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.
Hi @v-yilong-msft ,
Thanku for your response. Should I just add an index column and not add +0, Will that work perfectly?
Thanku for your explanation. I still have queries. Can u pls check your chatbox or mail as I have send u a text.
Is there a particular reason why you would like to use the Hierarchy over the Values (option 1 vs. option 2)?
No reason but I am just curious why they are performing differently. I wanna know why this is occuring @ExcelMonke
Basically I am trying to replace blank with 0 so I am using this dax
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
82 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
111 | |
110 | |
72 | |
71 |