Forum Discussion

indhu's avatar
indhu
Helper III
7 years ago
Solved

Summarized table with today date alone

Hi all,    I need help in getting a table/ measure with today date alone.    Sample data:   Table 1:   Date            | Gold company name  | Price  -----------------------------------------...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Indhu,

     

    The first one could be achieved by the Visual Level Filter. The second one could be solved by a measure. Please check out the demo in the attachment.

    Measure =
LOOKUPVALUE (
    Table1[Price],
    Table1[Date], TODAY (),
    Table1[Gold], MIN ( 'Table2'[Gold] )
)
    * MIN ( Table2[Balance] )

    Summarized-table-with-today-date-alone

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Indhu,

 

The first one could be achieved by the Visual Level Filter. The second one could be solved by a measure. Please check out the demo in the attachment.

Measure =
LOOKUPVALUE (
    Table1[Price],
    Table1[Date], TODAY (),
    Table1[Gold], MIN ( 'Table2'[Gold] )
)
    * MIN ( Table2[Balance] )

Summarized-table-with-today-date-alone

 

Best Regards,
Dale