Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everybody!
I need some time intelligence in my calendar for my visuals to show the last 6 fiscal months.
The calendar has the following structure:
Date - Fiscal Month Number
Every fiscal month has a different start and end date compared to the normal month. Functions like EOMONTH are no working.
How can I get a calculated column with TRUE/ FALSE if the date is in the last 6 fiscal months?
show the structure of your Fiscal Month Number. Ideally it also includes the year.
When you say "last six fiscal months" do you include or exclude the current fiscal month?
Thanks for your reply!
The structure is like:
Date | Fiscal Week | Fiscal Month | Fiscal Year |
31.12.2019 | 1 | 1 | 2020 |
01.01.2020 | 1 | 1 | 2020 |
31.01.2020 | 5 | 2 | 2020 |
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |