The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello everyone,
I require some help or someone to point me in the right direction please.
I have a table which has an output of below:
What I would like to achieve is a count of the status column (it is either Ok or Nok), but based on the latest point in the day. As some entries might be Ok earlier in the day, but then to Nok later or vice versa.
My current implementing I have is:
Solved! Go to Solution.
Just to close this one off. As I was pulling data from a SQL database, I managed to create a SQL query that changed the data as it came into PBI which presented the data on how I wanted it to be.
Just to close this one off. As I was pulling data from a SQL database, I managed to create a SQL query that changed the data as it came into PBI which presented the data on how I wanted it to be.
Hi @Begbie ,
Try the below dax-
Create a new summarized table by going in to the modelling tab and by clicking the new table option,
Summarized table =
Summarize(
'history',
'history'[ProductCode],
"MAx Date",MAX('history'[EvaluatedOn])
)
After this create a caculated column of concat in both the tables with Productcode and evaluated date.
Then create a another caculated column in the summarized table using the lookupvalue function take the status from the previous table to the summarized table based on the concat column.
This will solve your issue.
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Thank you for your help. I've done some of what you have mentioned but this is only showing the most recent date in the summarised table.
I have edited my opening post to reflect that the dates will be in the past and also added going forward, so will need to get a count of Ok or Nok for each product for each day, as this will be represented in a line graph to show historical numbers.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
63 | |
32 | |
21 | |
16 | |
15 |
User | Count |
---|---|
115 | |
33 | |
30 | |
24 | |
21 |