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.
Guys,
I been working with this dashboard, and is confusing; the targuet is to have in % meta dist a division of incomings and target; the conditios is if the starting date in the slider is before 01/01/2021 (January 1rst 2021) then I should have a "No aplica", and if it occurs after, then the result of the division should be showed. In the example the date is December 27th 2020, so the leyend "No aplica" should be on the card.
Any suggestion? Thanks a lot, regards,
Abelardo
Solved! Go to Solution.
Hey @Abevann ,
if you want to check for a date you have to compare against a date. Use the DATE function in DAX to create a fixed date:
DATE(2021, 01, 01)
If you just write "01/01/2021" you do a division, so 01 / 01 = 1 / 2021 = 0.0004948(...)
If you have any questions, just let me know. If my answer was helpful, I would be happy if you could give me a thumbs up.
Best regards
Denis
Hey @Abevann ,
if you want to check for a date you have to compare against a date. Use the DATE function in DAX to create a fixed date:
DATE(2021, 01, 01)
If you just write "01/01/2021" you do a division, so 01 / 01 = 1 / 2021 = 0.0004948(...)
If you have any questions, just let me know. If my answer was helpful, I would be happy if you could give me a thumbs up.
Best regards
Denis
Thanks a lot Denis!
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |