Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Year to Date calculation from Date table

Hello all,

 

I am fairly new to Power BI, and am a bit stuck at something.

I am creating an invoice visual from data pulled from ODBC source, and this is what it looks like as of now:

 

I want to add another column to this YTD visual, which is the target invoice value. So let's say the target invoice value is x for July 2022, the YTD target invoice will be 2x for August, 3x for September and so on; in the visual.

 

My idea for a solution was:

a) to add a column with a constant value (target amount for the year / 365) in the date table, which looks something like this: 

 

 

Please note the date table starts from 01/07/2022 till 30/06/2023.

 

(b) to write a YTD measure for the target value in the date table.

 

But I am unable to create a measure for some reason. Can someone offer an alternative solution to this?

 

Thanks in advance!

M

 

1 Reply