Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Period End Date | Financial Year | Financial Period | Description |
28/02/2021 | 2020/21 | 11 | Febuary 2021 |
31/03/2021 | 2020/21 | 12 | March 2021 |
31/03/2021 | 2020/21 | YE March 2021 | |
30/04/2021 | 2021/22 | 01 | April 2021 |
Assuming my page date filter is set as on/before 31/03/2021 I want to return the value of 12 based on the table above.
Any Ideas would be most welcome!
Thanks!!!!
@DDL1976 , Not very clear. The best way is have FY Period on you date table, and then you can get period for any selected value in slicer from date table
Measure =
var _max = allselected('Date'[FY Period])
return
////// Your calculation
You can not use slicer value in a column calculation
Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
7 | |
6 |