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.
Hello All,
Have run into an issue and looking for some urgent help.
I have the following Measure:
BM_RPX_EquipID = CALCULATE(SUM(RPXNetwork[Total_EquipmentIdentificationCount])/sum(RPXNetwork[Total_Count]),
ALL(GeneralStatistics),
DATESBETWEEN( 'Calendar'[Date],MIN('Calendar'[Date]), MAX('Calendar'[Date])))
Because I have SQL Source data that refreshes at different times, I need to wrap the MAX(Calendar[Date]) with an IF Statement.
I have a Date Slicer whereby User selects a Date Range.
In English, IF the Max of the Date Slicer is Today(), I need to subtract one day. Else, IF the Max of the Date Slicer is < Today, then all is good and I don't need to alter anything.
IF ( MAX (Calendar[Date])= Today(),MAX(Calendar[Date])-1, MAX(Calendar[Date]) )
I am Just not sure where to insert my IF Clause.
Appreciate all help with this one. Thx and Regards,
Solved! Go to Solution.
HI @rsbin
BM_RPX_EquipID =
VAR max_dt = IF ( MAX (Calendar[Date])= Today(),MAX(Calendar[Date])-1, MAX(Calendar[Date]) )
return CALCULATE(SUM( RPXNetwork[Total_EquipmentIdentificationCount]) /sum(RPXNetwork[Total_Count]), ALL(GeneralStatistics),DATESBETWEEN( 'Calendar'[Date],MIN('Calendar'[Date]), [max_dt]))
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
HI @rsbin
BM_RPX_EquipID =
VAR max_dt = IF ( MAX (Calendar[Date])= Today(),MAX(Calendar[Date])-1, MAX(Calendar[Date]) )
return CALCULATE(SUM( RPXNetwork[Total_EquipmentIdentificationCount]) /sum(RPXNetwork[Total_Count]), ALL(GeneralStatistics),DATESBETWEEN( 'Calendar'[Date],MIN('Calendar'[Date]), [max_dt]))
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hello @pranit828
Looks like your solution is working perfectly. Thank you so much for the quick response.
Can't test it completely due to other ongoing data issues, but so far looking real good.
Kudos and Thanks Again!!
Regards,
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 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |