Total month

[naveen73]

Hello,

Please see a screenshot where you can see that I have used the “Sales and Marketing Sample PBIX” PBI that can be downloaded from Microsoft website. On the left I have a date table where I have selected one day. The table on the left shows the transactions done on that date with the parameters.

What I want to achieve is on the right side, ALL the transactions done in the whole month. So, if I select the 15th of a certain month I want to see all the transactions done in that month, including the ones done after the 15th.

Is it possible to achieve this in DAX?

Thanks,

Naveen

[naveen73]

Hi @Ahmedx 

Thanks so much for putting your time into this. It is very helpfull!

Regards,

Naveen

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rh3yuIDulN_IdBCdh?e=utQYHH