Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

Campaign Values_New =
IF(FIRSTNONBLANK('Param'[Attributes],1)= "Total Adv Sales",SUMX(campaign_report,campaign_report[directRevenue]+campaign_report[indirectRevenue])+0)
ExcelMonke's avatar
ExcelMonke
Impactful Individual
2 years ago

Sure!

  1. 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:
    Year  Month  Value  
    2022Jan 
    2022Feb 
    2022Mar123
    2022Apr456
    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?
  2. 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 
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanku for your explanation. I still have queries. Can u pls check your chatbox or mail as I have send u a text.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thx for your help but I'm still confused. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous ,

        Thanku for your response. Should I just add an index column and not add +0, Will that work perfectly?