Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a variable Current USD Sales -Monthly that looks like this:
@tfeldt2020 , not sure I got it.
Assume the measures are Curr period and last period
Try something like
if (max(Table[Col]="Comp",[Curr period],[last period])
Thanks for your response! It looks like your if statement is alternating the measures based on the value of the column. What I want is for the prior sales field to calculate based on the row value of the column Comp as long as the row value matches the Comp slicer. Right now, when I filter on the Comp field, I get a blank value for the prior calculations because they were "Non Comp" during the prior period. I want to be able to compare the two values as long as the current period Comp value matches the slicer filter.
Hi @tfeldt2020
Do you still have issues with this?
If you've fixed the issue on your own please kindly share your solution. If any of the above posts helped, please kindly mark it as a solution to help others find it more quickly. Thanks!
Cheers,
Sturla
Hi @tfeldt2020
you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |