Forum Discussion

shrutik's avatar
shrutik
Frequent Visitor
3 years ago
Solved

Calculate month wise data in table visualization

I need to calculate month wise data such as when month slicer is present,it will show data upto that month .It should be in table visualization. 

For eg. If slicer value is 3,then individual columns upto march is shown in the table.

Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, shrutik 

     

    You can try the following methods.

    Sample data:

    Measure =
IF ( SELECTEDVALUE ( 'Date'[Month] ) >= MONTH ( SELECTEDVALUE ( 'Table'[Date] ) ),
    1,
    0
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, shrutik 

     

    You can try the following methods.

    Sample data:

    Measure =
IF ( SELECTEDVALUE ( 'Date'[Month] ) >= MONTH ( SELECTEDVALUE ( 'Table'[Date] ) ),
    1,
    0
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.