Forum Discussion
Conditional Formatting by Row Across Multiple Measures
Hello,
First, thank you so much for the hard work helping me. The only issue i'm having is that each individual Month is in fact it's own unique measure (please see screen shot). The reason for this is because i'm appending a data file with YTD revenue information and appending onto the previous one. In this case, I have subtract each previous month in order to get the revenue earned "for that particular month" - not YTD. So, since each month is it's own unique measure....in your example, i cannot use one particular field (Sum of Sales) to capture all months. Is there a way to use the MINX and MAXX features in your formula, but list out each unique month measure? Please let me know if this makes sense.
Hi gowen_WHG ,
Are the measures circled in red in the figure below calculated using different logic? Is it possible to combine these into one measure? If it is convenient, could you please provide me with the formulas and calculation logic for these measures? I'll check if there are other alternatives to achieve the same function later. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
- gowen_WHG4 years agoNew Member
Hi Anonymous,
Yes, they are calculated using the same logic. I have a sample simplified pbix with these data. I clicked the link and says that I need to be a super user to upload...how do i do that, and how can I get you this pbix file?
I cannot thank you enough for your time helping me with this.
Sincerely,
- gowen_WHG4 years agoNew Member
Hello Anonymous ,
Thank you so much for all of your help, but my IT department head notified me today to refrain from sharing files...even sample ones. I will continue to refer to your original measure coding and spend more time with it to try and make it work. Thanks again!
- Anonymous4 years agoNot applicable
Hi gowen_WHG ,
You can refer the following link to upload your pbix fileto other locations (grant the access to me) and share the link with me. Thank you.
How to upload PBI in Community
Best Regards