DAX

[kalpana]

Hi

i want DAX formula for MTD, QTD, YTD ..these three measures , i want to put in slicer. when i click MTD, Graph should show only  from start of month to till date. i.e)dynamic axis

Thankz in advance

[Anonymous · Accepted solution]

Hi @kalpana

Check out the article

Creating a Dynamic, Parameterized Measure in DAX

https://sqlserverbi.blog/2014/04/19/creating-a-dynamic-parameterized-measure-in-dax/

If this helps please give KUDOS and also accept it as a solution