Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic calculation based on Date selection

Hello Team,   I have a separate date table which has a column like distinct(datasource[CutoffDate]). then I use this column to get calculation based on the month as shown below. **( cut off date co...
Need Help
Show and Tell
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

What is your slicer based on, Datetable2[MyDate]?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    yes, the slicer is based on the myDate  table.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      HI Anonymous ,

      Current power bi not support to create dynamic column/table based on slicer/filter. Please modify your formula to write a measure to achieve your requirement.

      Regards,

      Xiaoxin Sheng