Forum Discussion
Calculated column for getting difference between current and previous values
rubymaya , with a date table try calculation like these
Last Day Non Continous = CALCULATE(sum('order'[Qty]),filter(all(Table),Table[Date] =MAXX(FILTER(all(Table),Table[Date]<max(Table[Date])),Table[Date])))
Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd(Table[Date],-1,Day))To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/Hi Amit,
I cant find the pattern, but sometimes it works when i swap the fields in between, for eg : when i drag the qty, the measure disappear, when i remove the qty it appears back,... see 2 screenshots below appear, then disappear
i have relationship between fact table that we calculate and bridge 'table'
Ok, would you tell a little bit what it does, i still cant get the brackets right in the measure,...
Hi,
Ok i parse the error, but the value is not correct, it doesnt group by area and aging_day, see below screenshot
Hi Amit,
I cant find the pattern, but sometimes it works when i swap the fields in between, for eg : when i drag the qty, the measure disappear, when i remove the qty it appears back,... see 2 screenshots below appear, then disappear
i have relationship between fact table that we calculate and bridge 'table'