Forum Discussion

amikm's avatar
amikm
Icon for Helper V rankHelper V
5 years ago

Issue with Date during closed year

I have a table that has all the dates from 01/01/2020 to  31/12/2020 I am writing a DAX measure to calculate Sales based on dates Sales=CALCULATE(SUM(Sales[Sale]), FILTER(Sales,Sales[CYPY]="CY")) ...
Need Help
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi amikm ,

 

Can you attach a small sample data file, so that I can try this at my end?

 

Thanks,

Pragati