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...
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
Campaign Values_New =
IF(FIRSTNONBLANK('Param'[Attributes],1)= "Total Adv Sales",SUMX(campaign_report,campaign_report[directRevenue]+campaign_report[indirectRevenue])+0)