I'm trying to present the data to my team in the following fashion, can you help me with the DAX.
Go to Solution.
Hi @kkalyanrr ,
Sorry for my late reply...
Please use the following formula to create a new table:
Table 2 =
"FY" & MIN ( 'Table'[Year] ) & "-"
& MAX ( 'Table'[Year] ),
FILTER ( 'Table', 'Table'[YearMonth] = MIN ( 'Table'[YearMonth] ) ),
FILTER ( 'Table', 'Table'[YearMonth] = MAX ( 'Table'[YearMonth] ) ),
"w", [Opening Balance] - [ClosingBalance]
The final output looks like this:
Please take a look at the pbix here.
Best Regards,Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
will this help? https://www.youtube.com/watch?v=XjAMee2LhKE
Proud to be a Super User!
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.