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 the below table and trying to make an end of month formula, but I don't the formula calculates wrong.
Solved! Go to Solution.
That is the answer of my question for anyone interested in
That is the answer of my question for anyone interested in
@Anonymous, do it in Power Query. It'll be sooooo much simpler. In PQ, split the FY column and get the first component, then create a string from Month and the new column adding "1" to obtain something like "June 1, 2019", then turn this into a real date using PQ functions or the functionality in the ribbon and then use the datetime intelligence in PQ (not in DAX!), to get the last day of the month. It's much easier done than said!... which is the best part of doing such things in PQ. And it'll be 100% error-free.
@Anonymous I am not good in Query, can you help me, please?
@Anonymous , Try like
EOM =
var _col = if([FYPeriod] >=6 , [FYPeriod] -6, [FYPeriod] +6)
return
eomonth(date(left([FY],4),_col,1),0)
@amitchandak I don't know why my reply wasn't shown up here
the formula is incorrect again
i cannot calculate years
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 |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
73 | |
50 | |
45 | |
20 | |
17 |