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.
I am trying to compare the dates in the maximum Selected date with the column of the table via If and Else statement and it is not working as expected. It seems like somehow it is not recognizing the measure as dates.
My Measure to have the maximum date selected:
Thank you for your reply. Then what you suggest?
For your information, I want to filter the table based on the minimum and maximum selected date value from the user and create the graphs etc based on that.
I am trying for Calculate table as well but somehow that is not working as well.
I have a SSRS report where user selects a date and then based on that same date two different tables gets filtered and the report gets shown. I am trying to create that same report in Power BI.
Thank you I know that! I may not be that new like you are thinking I am. I have tried to search for answers and could not find the one I am looking for that is why I posted this and I think is the genuine post which lots of people might be searching answers for. I know what slicers can do.
If you do not know the exact answer then it would be better not to reply.
Thanks!
You need to aggregate that column somehow in your measure. For example,
PostDateCheck = if(MAX(Maint[Post_Date])>=[MaxPostDateSelected],"YES","NO")
Even though there is a single value on that row, you still need an aggregation.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank you for your quick reply. It is somehow still now working.
Please see in the pictures. The first one is giving the selected date for the measure MaxPostDateSelected and the other one is the table that I am trying to use the formula to.
HI @Anonymous ,
Columns in Tables are static and they do not respond to slicers which generate value of the selected date dynamically.
A measure will helps you in such cases.
Try to create a measure and this will work.
PostDateCheck = if(MAX(Maint[Post_Date])>=[MaxPostDateSelected],"YES","NO")
Hope this helps you.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Thanks!
But, I will not able to filter the page with the measure though.
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 |
---|---|
42 | |
19 | |
18 | |
16 | |
15 |
User | Count |
---|---|
51 | |
26 | |
22 | |
17 | |
16 |