Forum Discussion
DAX query
Hi, I have my report visualization as below. The Instance column has various sources in my data. So, for each instance, the table visual show should only 1 row per Instance i.e., if the Instance is ...
Hi roopa_123
Yes, you may also build a table with that aggregation. Select "Modelling" > "New table" from the top menu and write the following expression:
New table = SUMMARIZE('Table', 'Instance', "Last Run", MAX('Table'[Latest successful runs]), "Total Runs", SUM('Table'[Runs]))
This should create a new table in your data model.
Hi webportal ,
Tried your solution, but it is not working as per the expected sample that I need 🙁
I also need to use other columns from my original table to be used in the reports. In that case, how can I write a DAX to get dynamic table?
Is there any other way?
