Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi the community 🙂
i have a question on a report power bi
We does security audits workplaces
I have a table with information workplace/date and result Audit, if need i have too the list complety workplaces
on my power bi i have a map to site and i would display the last result by workplace, i have used the card for display the result
i can't found (between M-query or Dax-Query) the solution for that
can you help me ?
thanks
Solved! Go to Solution.
Yes, I can help you with that.
To display the last result by workplace in Power BI, you can use the following DAX formula:
Replace 'Table' with the name of your table and 'Date' and 'Result' with the names of your columns for date and result, respectively. This formula will calculate the maximum date for each workplace and then return the result for that date.
You can then use this DAX formula in a table or visual to display the last result by workplace. For example, you can create a table with the workplace name and the last result using the above formula.
Yes, I can help you with that.
To display the last result by workplace in Power BI, you can use the following DAX formula:
Replace 'Table' with the name of your table and 'Date' and 'Result' with the names of your columns for date and result, respectively. This formula will calculate the maximum date for each workplace and then return the result for that date.
You can then use this DAX formula in a table or visual to display the last result by workplace. For example, you can create a table with the workplace name and the last result using the above formula.
Thanks for your speedy answer.
I tried, it work so thank for that too 🙂