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'
omg, im looking at the first column, for sure there will be no value coz it s the first one
Thx Amit, I think it;s for working now, would you mind to explain a little bit.
Hi Amit,
Is it possible to ignore Column Category from the pivot in terms of calculation, but still showing them on Pivot.
EG: If I show WW column, every Monday, it will not minus the qty from Sunday previous week. How do I address this because we still want to show the WW
Thx