Forum Discussion
Choosing the right visual
- 8 years ago
Hello Fahd24,
You can use KPI Grid by MAQ Software in the following way:
You can concatenate categorical columns from Table 1 using DAX, to have all this information in a single column (like Site and Description in the above image).
You can drag the various date column from Table 2 (which has multiple values) to form the hierarchy. And the measure columns in the Measure Data bag.Alternatively, you can also use Grid by MAQ Software as follows (or the default Table visual in a similar way):
If you wish to display only the latest update from Table 2, for every IdEvent, use the following approach in Grid by MAQ Software:
Thanks
Not exactly certain of what you are trying to display but with start and end dates, you may need something like GENERATE. See my quick measure here:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364