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 all,
I have column of billing dates, i want to filter out the current financial dates from that column. Current financial year means april 2020 to march 2021.
Please help me out. How i can do it.
Thanks
Solved! Go to Solution.
@Anonymous ,
1. What exact output you want.
2. Why you do not a date table.
You can try a new column like this your table
New Column =
var _year = if(month(today())<=3, year(today())-1, year(today()))
var _st = date(_year,4,1)
var _end = eomonth(_st,11) //if need make 11 as 12
return
if(Table[Date] >= _st && Table[Date] <=_end , "This FY", "Other")
@Anonymous , it is taken from 1-Apr-2020 to 31-Mar-2021
@Anonymous , Output is not clear.
You can create a calendar and use that. You use this blog to get the calendar April-March
Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
you can also refer
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA
Hi @amitchandak
I don't want to create any financial year column but want to filter out dates from the column lying in current financial year.
Thank you.
@Anonymous ,
1. What exact output you want.
2. Why you do not a date table.
You can try a new column like this your table
New Column =
var _year = if(month(today())<=3, year(today())-1, year(today()))
var _st = date(_year,4,1)
var _end = eomonth(_st,11) //if need make 11 as 12
return
if(Table[Date] >= _st && Table[Date] <=_end , "This FY", "Other")
Thank you @amitchandak . This solution worked for me.
Can you explain me that current financial year is taken as 2021 or 2020?
@Anonymous , it is taken from 1-Apr-2020 to 31-Mar-2021
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |