The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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
Solved! Go to Solution.
If you make a measure like:
LastupdateM = MAX('Table 1'[Date])
Then yes.
If you make a measure like:
LastupdateM = MAX('Table 1'[Date])
Then yes.
User | Count |
---|---|
160 | |
110 | |
96 | |
86 | |
75 |
User | Count |
---|---|
157 | |
137 | |
132 | |
81 | |
61 |