Forum Discussion

janeca's avatar
janeca
Frequent Visitor
9 years ago
Solved

Slicer calculations

Hi,

 

On my power bi file i have 3 data tables.

 

Table 1 

Date

Operation

Type

Qtd

 

Table 2 

Operation

Type

Lastupdate

 

Table 3 - Calendar

Date

Month

Year

 

On my report view i have a slicer for month and year, so i want when i selected diferente month's and year at the slicer the lastupdate on data table 2 change.  The lastupdate is last date on the table 1.

 It's this possible? 

 

Thanks

 

 

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    If you make a measure like:

     

    LastupdateM = MAX('Table 1'[Date])

    Then yes.