Forum Discussion
Calculated Table
Hi,
According to your further description, i create a seperate date slicer table:
Then try this measure:
Measure = IF(MAXX(ALL('Table 1'),'Table 1'[date])<>SELECTEDVALUE('Date Slicer'[Date]),IF(MAX('Table 1'[date])=MAX('Table 2'[Date]),1,0),IF(MAX('Table 1'[date])=SELECTEDVALUE('Date Slicer'[Date]),1,0))Apply this measure to the table1, when you choose the max date in table1, it shows the max date's data:
When you choose other date which is not equal to the max date in table1, it shows the data with table1[date]=table2[date]:
Here is my test pbix file:
Expect your reply!
Best Regards,
Giotto Zhi
The second table will have only one value ..My mistake.
Basically, select coulmns/records from table1 based on one date from table 2
Table2-
| date |
| 03/11/2020 |
Does is change how we implement the DAX?
Hi,
Do you mean that the table 2 has more than one date, and when you choose one date in table2[date] slicer, it will show the expected result you posted？
If so, please try this measure:
Measure = IF(MAX('Table 1'[date])=SELECTEDVALUE('Table 2'[Date]),1,0)Apply this measure to the visual, when you select one date in slicer, it shows:
If you only have one date in your initial table 2, the first way in my original reply can solve it.
If you still have any issue, please for free to let me know.
Best Regards,
Giotto Zhi
Zhi, Thank you for your feedback so far.
There is a small change .I should have been more specific from the begining.
We are taking the MAX of date from Table 1 but what if we have a pick a date that is not the MAX but is equal to the date from the Table 2.
Table 1 -
country rate date MX .5 03/10/2020 MX .8 03/11/2020 US .7 03/10/2020 US .9 03/11/2020 MX .8 03/20/2020 US .7 03/20/2020 Table 2
Date 03/11/2020 Result Table -
country rate date US .9 03/11/2020 MX .8 03/11/2020 bumping up..
Bumping up..
Hi,
According to your further description, i create a seperate date slicer table:
Then try this measure:
Measure = IF(MAXX(ALL('Table 1'),'Table 1'[date])<>SELECTEDVALUE('Date Slicer'[Date]),IF(MAX('Table 1'[date])=MAX('Table 2'[Date]),1,0),IF(MAX('Table 1'[date])=SELECTEDVALUE('Date Slicer'[Date]),1,0))Apply this measure to the table1, when you choose the max date in table1, it shows the max date's data:
When you choose other date which is not equal to the max date in table1, it shows the data with table1[date]=table2[date]:
Here is my test pbix file:
Expect your reply!
Best Regards,
Giotto Zhi
Thank you!