Forum Discussion
CJKPowerBI
Helper I
Helper ISum values with latest dates per year
hello all, i have the below data 6/30/2020 - 12/31/2020 - 6/30/2021 - 12/31/2021 - 6/30/2022 Item 1 $100 $150 $200 $250 $...
Hi,
Please check the below pictures and the attached pbix file.
I suggest unpivotting a table like below, and then add [Year] column like below.
After loading the table into Power BI, create a measure like below, and put it into a matrix visualization.
Hi,
Thank you for your feedback.
Please check the below picture and the attached pbix file, that I added one more measure to fix the total row in the visualization.
Jihwan_Kim
Super User
Super UserHi,
Thank you for your feedback.
Please check the below picture and the attached pbix file, that I added one more measure to fix the total row in the visualization.
CJKPowerBIHelper I
Helper I
coming back with your formula, can we add a Filter over there to return only results from a column named TYPE and the selection to BALANCE?
let me know pls.