Forum Discussion
Show data progress in time
Hi Community,
I have a very simple data from excel sheet. I want to show amount in all months from "Opened" till "Closed" Status.
Essentially I want to show from Jan till July for this ID "a".
Jan is in Open Status therefore Feb will be in "Open"
March is Pending so April will be in "Pending"
May is Approved so June will be in "Approved"
I created a new COlumn :
Feb , APril and June doesnt show in the graph
Please help 😄
schoden ,My bad
calculate(lastnonblankvalue(Date[Date],max(Table[status])), filter(allselected(Date),Date[Date] <=max(Date[Date])))
5 Replies
schoden , with help from a date table, try a measure like
filter(lastnonblankvalue(Date[Date],max(Table[status])), filter(allselected(Date),Date[Date] <=max(Date[Date])))
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 :radacad sqlbi My Video Series Appreciate your Kudos.
schoden ,My bad
calculate(lastnonblankvalue(Date[Date],max(Table[status])), filter(allselected(Date),Date[Date] <=max(Date[Date])))
