how to pass parameter into dax calculation

[sunil222]

how to pass parameter into dax calculation , i have fy24 plan column i.e dax calucltion based on 2023-04-01 to 2024-03-31.

now requirement is filter on the year and month columns as a  slicer if user selects the any month and year it shows the data in that fy24 plan column, my manager suggets create a parameter and utilize it.

Please help me on this?

[lbendlin]

Parameters are expressions, not partitions. They are only exposed in Power Query and in the Power BI Service.  To use them in DAX you need to convert them to partitions  (ie enable load).

[danextian]

Hi @sunil222 

As always, please provide a usable sample data  (not an image, please don't make us manually encode your data) that fully encompasses your use case and the expected result using that sample data. Also, please take note that a calculated column ins static until it is modified again or the underlying data is refreshed so it won't respond to the change in parameter value via slicer selection.