Solved: Getting value from pivot

guyinazo · ‎01-12-2022

I have queries that pull in a file from yesterday and take the same file from today and list out any differences. It is working. The queries are pivots after the ID column. One of the attributes is Name. Is there a way I can reference the value from that attribute? Even if it is a column, or measure, that is the name for that one record. Thanks for the information

amitchandak · ‎01-12-2022

@guyinazo ,If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

If you plan to compare power bi files you can use ALM toolkit

How to ALM toolkit to merge Power BI files/Meta: https://youtu.be/lio62VRkOnc

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

amitchandak · ‎01-12-2022

@guyinazo ,If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

If you plan to compare power bi files you can use ALM toolkit

How to ALM toolkit to merge Power BI files/Meta: https://youtu.be/lio62VRkOnc

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube