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.
one column has month-year and another column is weekend-dates, like below image
i want to have only one matching month and year of the month column, like below
the issue is starting of month and end of month sometimes present in previous month as highlighted in first image,
can someone help me get the result of 2nd image, any date is fine as long it is only one date matching the month column, so i could use it in my slicer.
@grey @FreemanZ @Jihwan_Kim any help please. thank you
Solved! Go to Solution.
Hi @Evanooruvan
You can refer to the following solution.
Sample data
Create a measure
Measure =
VAR a =
MINX (
FILTER (
ALLSELECTED ( 'Table' ),
EOMONTH ( [wk_end_dt], 0 ) = EOMONTH ( MAX ( 'Table'[Date] ), 0 )
),
[wk_end_dt]
)
RETURN
IF ( MAX ( 'Table'[wk_end_dt] ) = a, 1, 0 )
Then put it to the visual filter.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Evanooruvan
You can refer to the following solution.
Sample data
Create a measure
Measure =
VAR a =
MINX (
FILTER (
ALLSELECTED ( 'Table' ),
EOMONTH ( [wk_end_dt], 0 ) = EOMONTH ( MAX ( 'Table'[Date] ), 0 )
),
[wk_end_dt]
)
RETURN
IF ( MAX ( 'Table'[wk_end_dt] ) = a, 1, 0 )
Then put it to the visual filter.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Evanooruvan
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
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 |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |