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.
Here is the dataset. Description of "Cumulative Units": Hillsborough did 2 units on 2/1, 0 units on 2/2, and 2 units on 2/3 for a total of 4 units.
I need to create a measure to show a colum of "Units per Day". The table visual should look like this:
Thank you for your time an effort!
Bob
Solved! Go to Solution.
Hi @bob57 ,
You can create a measure
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
I replaced 'Table8'[Actual] with 'Table'[Cumulative Units] and the measure worked perfectly. Thank you for your time, effort, and expertise.
Bob
Hi @bob57 ,
Table8[Actual] refers to my dataset.
You can replace this with Cumulative Units of your data set.
Hope this help solve your problem. Please mark as Solution if this helps.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @bob57 ,
You can create a measure
Forgive me for not fully understanding your solution. To what does 'Table8'[Actual] refer? Thank you.
Hi @bob57 ,
Table8[Actual] refers to my dataset.
You can replace this with Cumulative Units of your data set.
Hope this help solve your problem. Please mark as Solution if this helps.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @bob57 ,
You can create a measure
I replaced 'Table8'[Actual] with 'Table'[Cumulative Units] and the measure worked perfectly. Thank you for your time, effort, and expertise.
Bob
Hi @bob57 ,
You can create a measure
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
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 |
---|---|
45 | |
26 | |
22 | |
12 | |
7 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |