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.
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?
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |