Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 😄
Solved! Go to Solution.
@schoden ,My bad
calculate(lastnonblankvalue(Date[Date],max(Table[status])), filter(allselected(Date),Date[Date] <=max(Date[Date])))
@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])))
Hi @amitchandak ,
Sorry for for gap but I am struggling to get lastnonblankvalue for EACH ID in Each MONTH ?
For example in Jan 2020 there are two IDS - show all value for all each ID.
Will really appreciate.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |