Forum Discussion
Calculate variance according to different dates
Hello, I am getting started with power bi and I have an issue with calculating the variance between actual values and target values. I have two tables actual and target table. the actual table ...
Hello, Thank you for your reply. let me explain it more clearly.
For example:
- I have the target dates are 6-June with a target value 100 and 31-Dec with a target value 200,
- and the actual date is 31-Aug, so the target date corresponding is 31-Dec .
So getting the target value according to the actual date and target date comparison
Again, I may have explained wrongly,
I have succeeded to implement it in excel by using the match formula. but using Dax I am blocked..
Thank you again