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...
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
Campaign Values_New =
IF(FIRSTNONBLANK('Param'[Attributes],1)= "Total Adv Sales",SUMX(campaign_report,campaign_report[directRevenue]+campaign_report[indirectRevenue])+0)
When I am not using +0 the visual is working perfectly under hierarchy level but when i try to use +0 the hierarchy shows all the months which are not even in power bi.