Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am struggling to convert a series of Tableau Fixed LOD's in my Power BI report. I have read just about every post on this matter that is currently on the discussion board and have not been able to figure out an answer. If I can figure at least this one out, I think I can figure out the rest.
The Tableau LOD reads as follows:
Projected Over Under = { FIXED [Project Name],[accountcode],[projectedoverunder]: AVG([projectedoverunder])}
I've tried the following, which you'll see in the table below:
1) Creating a calculated column using the following formula:
Facility | Projected Budget Over/Under |
Facility 1 | -52 |
Facility 2 | -450,000 |
Facility 3 | -874, 373 |
Facility 4 | -1,500,000 |
Facility 5 | -1,608,053 |
Facility | Projected Budget Over/Under 3 | Projected Budget Over/Under | projectedoverunder *original field from dataset* |
Facility 1 | -125,577.19 | -412 | -412 |
Facility 2 | -125,577.19 | -450,000 | -450,000 |
Facility 3 | -125,577.19 | -5,186,480 | -5,186,480 |
Facility 4 | -125,577.19 | -1,500,000 | -1,500,000 |
Facility 5 | -125,577.19 | -55,850,173 | -55,850,173 |
Thank you in advance!!
Not quite understand your requirement, could you plz kindly share your original sample and expected results?
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |