Forum Discussion

arvindyadav's avatar
arvindyadav
Icon for Post Partisan rankPost Partisan
7 years ago
Solved

How may I know Current Hour Data

Hi Team,   How may I know that the current hour of revenue of yesterdays or day before yesterdays in power bi. and the data format is below where hour_id is hour:-  
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi arvindyadav ,

    Please try the measure below.

    today_rev = CALCULATE(MAX('Table'[Revenue]),FILTER('Table','Table'[date]=TODAY()))
yesterday = CALCULATE(MAX('Table'[Revenue]),DATEADD('Table'[date],-1,DAY))

    Here is the output.

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi arvindyadav ,

Please try the measure below.

today_rev = CALCULATE(MAX('Table'[Revenue]),FILTER('Table','Table'[date]=TODAY()))
yesterday = CALCULATE(MAX('Table'[Revenue]),DATEADD('Table'[date],-1,DAY))

Here is the output.

Best Regards,

Cherry

arvindyadav's avatar
arvindyadav
Icon for Post Partisan rankPost Partisan
7 years ago

Hi v-piga-msft ,

 

Thank You So Much :v:

It is working fine.