Forum Discussion
Measure with IF statement in DATE
I am new to this community and looking for help with a measure having IF statement using dates. I have fiscal year to date Operating Revenue, but I would like to calculate monthly operating revenue,...
You can use a measure like this:
Monthly Operating Revenue = VAR __SelectedMonth = SELECTEDVALUE( DateDim[Month] ) VAR __MonthlyOperRev = IF ( __SelectedMonth = "January", "Whatever you want in case of January", [Total Operating Revenue]-[Monthly Operating Revenue], ) RETURN __MonthlyOperRevPlease give it a thumbs up if this helps!
YukiK
Impactful Individual
Impactful IndividualYou can use a measure like this:
Monthly Operating Revenue =
VAR __SelectedMonth = SELECTEDVALUE( DateDim[Month] )
VAR __MonthlyOperRev =
IF ( __SelectedMonth = "January", "Whatever you want in case of January", [Total Operating Revenue]-[Monthly Operating Revenue], )
RETURN
__MonthlyOperRev
Please give it a thumbs up if this helps!