Forum Discussion
Showing the wrong dates
I am using in the model a created calender table for the dates but somehow it shows the wrong dates in the graph. How can this be solved?
koningii , On single date table, One active one inactive join and two measure
example
Started = CALCULATE(COUNTrows(Table]),USERELATIONSHIP(Table[IFC_ACT],'Date'[Date]),not(ISBLANK(Table[IFC_ACT])) )
Ended = CALCULATE(COUNTrows(Table]),USERELATIONSHIP(Table[IFC_PLAN],'Date'[Date]),not(ISBLANK(Table[IFC_PLAN])))
refer