Forum Discussion
roncruiser
Post Patron
5 years agoDynamic Delta Columns Based on Pivot Table configuration
From any two different filenames (there could be more than two files but it's always the delta between just two files), I've been trying to create a measure to dynamically add columns showing the dif...
Anonymous
5 years agoNot applicable
Hi roncruiser ,
I created a sample pbix file() for you, please check whether that is what you want.
If the above one is not working, please provide the measure formula which you apply in Values field and your expected result with example and screenshots. Thank you.
Best Regards
- roncruiser5 years ago
Post Patron
Hi Anonymous
I am not able to utilize SELECTEDVALUE in DAX Excel. The deltas will need to be utilized for both PowerBI and Excel. Mainly for Excel. I will utilize the Delta columns in DAX for Excel only. I read that SELECTEDVALUE is not available or utilized for Excel.