Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hey,
Am quite new to PowerBi and was given a project to do. am trying to get [amount] for 2019 2020 and 2021 fiscal year but most end on the day and month of today.
example:
2019 = value from April 01 2019 to September 27 2019 (day of today)
What is the DAX formula please?
Measure for the value= [NET]
Date calendar= Calendar[Date]
last day=F_national[EOMDate]
@loopingmurdock in this case you will need to create financial dates in your date table and then you can use that to create your measure
Start year= startofyear([date], "6/30" )
end year= endofyear([date], "6/30")
use below link for help
Solved: How to get financial year with dax table wit this ... - Microsoft Power BI Community
Proud to be a Super User!
User | Count |
---|---|
119 | |
66 | |
66 | |
56 | |
50 |
User | Count |
---|---|
177 | |
84 | |
70 | |
64 | |
54 |