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.
Hi,
Our Fiscal Halves are:
H1: 2/1 - 7/31
H2: 8/1 - 1/31
I am attempting to mark both the current and prior fiscal half completed months as true as we progress through the current half. I only want to show months that have been completed and not months we are currently in. For example if today is 9/20 the only month in the current half I want shown as completed is August since it is 100% closed. At the same time I want the previous half to then mark the same quantity of months as TRUE, in this case it would be February. I essentially want it to mark from the start of the half to the most recent completed as TRUE and then to also mark the same quantity of months in the previous half as true as well.
Example:
Hi @PowerBIUser23 ,
Can you provide relevant screenshots and relevant test data and describe them, so that I can answer for you as soon as possible.
Looking forward to your reply.
Best Regards,
Henry
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |