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,
I am looking to display KPI Values per Business Unit on a bar graph. The datas are filtered by Year and Quarter thanks to a slicer.
KPI Values are fielded every 1st day of the month. My date column in my date table is only 1st day of the month-year. So far no problem.
However, the KPI value may not be fielded every month and would need to get the last available value as the current value. This should be done per KPI Name, per Business Unit.
I have been searching with the LastNonblank function but haven't managed to make it work. Would you have any ideas ?
My data model is like this :
Completed KPI (Fact Table) | KPI | Date | Business Unit |
id Date id KPI id Business Unit id KPI Value | id KPI Name | id 01-Month-Year Year Quarter-Year | id Business Unit Name |
Thanks for your help
Solved! Go to Solution.
I had to do some modification with the DAX but based on what you did I managed to make it works.
Thanks !!
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |