Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everybody,
so just recently I started using Power-BI and I just can't figure out how to calculate year to date values. The problem is, I can't use the classic apprach with a date table because my data only consists of monthly values, not daily.
I've tried everything but I just can't figure it out.
This is the structure of my data:
Columns: KPI Month Year Legend
Vaues: Sales 01 2018 Target/Actual
One remark: in the "Month" Column there the word "Target" also occurs (This is because we want an extra bar for the target to be visible in the bar charts)
I basically just want to calculate the YTD value of actual sales based on the months. I already have a "Dates" table that contains days, months, year etc. if that is relevant.
Thank you so much in advance!!
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |