Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |