Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I am new to Power BI so I am trying to learn as much as i can about how it sould be set up and how to create the measures as efficiently and easily as possible. We have a day table and a manufacturing hours table. We are trying to create the YTD, MTD, Prior YTD measures. I understand how to create them using the expression below. However, I would like to not specify "what to calculate", is there a way to make it dynamic? I want to pick YTD at a very high level and then add the specific table column data to the matrix/table. Please forgive me if this is hard to understand.
I would like to be able to choose the month and then the time perspecive like the screen shots below. Is there a way to accomplish this?
Thanks in advance for all your help and input!
Denise
Solved! Go to Solution.
Hi @dkresge
You can refer to this article.
Month Year = FORMAT([Date],"mmmm yyyy")
3.Create ‘Measure Selection’ measure:
Selected Measure = VAR MySelection = SELECTEDVALUE ( 'Measure Selection'[Measure Name], "MTD" ) RETURN SWITCH ( TRUE (), MySelection = "MTD", [Measure MTD], MySelection = "QTD", [Measure QTD], MySelection = "YTD", [Measure YTD], MySelection = "Prior YTD", [Measure Prior YTD], [Measure MTD] )
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dkresge
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
Best Regards
Maggie
Hi @dkresge
You can refer to this article.
Month Year = FORMAT([Date],"mmmm yyyy")
3.Create ‘Measure Selection’ measure:
Selected Measure = VAR MySelection = SELECTEDVALUE ( 'Measure Selection'[Measure Name], "MTD" ) RETURN SWITCH ( TRUE (), MySelection = "MTD", [Measure MTD], MySelection = "QTD", [Measure QTD], MySelection = "YTD", [Measure YTD], MySelection = "Prior YTD", [Measure Prior YTD], [Measure MTD] )
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |