Forum Discussion
Need guidance
- Anonymous3 years ago
Hi Puja ,
Please refer to my pbix file.
Measure = VAR _1 = SELECTEDVALUE ( data[Date] ) VAR _format = FORMAT ( _1, "MMM" ) VAR _YEAR = YEAR ( _1 ) RETURN IF ( _1 = SELECTEDVALUE ( 'Table'[Date] ), 1, IF ( _format = SELECTEDVALUE ( 'Table'[ Month] ) && _YEAR <> SELECTEDVALUE ( 'Table'[year_colun] ), 1 ) )How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Puja ,
Please refer to my pbix file.
Measure =
VAR _1 =
SELECTEDVALUE ( data[Date] )
VAR _format =
FORMAT ( _1, "MMM" )
VAR _YEAR =
YEAR ( _1 )
RETURN
IF (
_1 = SELECTEDVALUE ( 'Table'[Date] ),
1,
IF (
_format = SELECTEDVALUE ( 'Table'[ Month] )
&& _YEAR <> SELECTEDVALUE ( 'Table'[year_colun] ),
1
)
)
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Thank you for your time. Your solution working for some dates only. In this example if user choose 12/4/2021, then same date and previous year date.
Another example.
Much appriciated for your help