Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
HI everyone, I have one question and hope you can help me.
Now I am working with live data, and I have one matrix table wich one should shows "CFYTD" and "PFYTD".
But I can't show neccessary data (look in pictures below).
There was blank columns wich ones should be hide and show only two columns with current and previous date. And its will be helpfull two be third column with variance (current - previous)/ previous
Here are what I am using
CFYTD and PFYTD are measures.
Live data don't allow "edit query", "enter data"... or use "new column", and I have only measurs.
Solved! Go to Solution.
Hi @Anonymous ,
>>There was blank columns wich ones should be hide and show only two columns with current and previous date. And its will be helpfull two be third column with variance (current - previous)/ previous.
I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? Do mask sensitive data before uploading.
Best Regards,
Amy
Hi @Anonymous ,
>>There was blank columns wich ones should be hide and show only two columns with current and previous date. And its will be helpfull two be third column with variance (current - previous)/ previous.
I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? Do mask sensitive data before uploading.
Best Regards,
Amy
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |