cancel
Showing results for
Did you mean:
Helper IV

## Can someone help me fix this DAX formula?

YTD Total W/O & Disc = Calculate(TKD[Total Adjust])+TKD[Agreed Disc.]),FILTER(Dates,Dates[YTD Flag]="Show YTD")

Getting the Error "The syntax for ',' is incorrect error.  I'm not sure what's wrong here.  Any help would be greatly appreciated!

Thanks,

Jordan
1 ACCEPTED SOLUTION
Resolver II

Hi @jmays86 ,

Try this:
YTD Total W/O & Disc = Calculate(TKD[Total Adjust]+TKD[Agreed Disc.], Dates[YTD Flag]="Show YTD")

Thanks,

Dheeraj

If this post helps, then please consider Accept it as the solution and give thumbs up to help the other members find it more quickly.

2 REPLIES 2
Super User II

YTD Total W/O & Disc = Calculate(SUM(TKD[Total Adjust])+SUM(TKD[Agreed Disc.]),FILTER(Dates,Dates[YTD Flag]="Show YTD"))

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Resolver II

Hi @jmays86 ,

Try this:
YTD Total W/O & Disc = Calculate(TKD[Total Adjust]+TKD[Agreed Disc.], Dates[YTD Flag]="Show YTD")

Thanks,

Dheeraj

If this post helps, then please consider Accept it as the solution and give thumbs up to help the other members find it more quickly.

Announcements