Forum Discussion

kunkumuriarjun's avatar
kunkumuriarjun
Icon for Helper I rankHelper I
10 years ago
Solved

how to do calculation to get the DaysFromToday item

When data gets from Google Analytics its automatically create Datasets, Reports and Dashboards in Power BI web   In datasets we have Fields -> Overview -> DaysFromToday item.   From Power BI Desk...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    kunkumuriarjun

     

    I have no idea on what your GA dataset is like, according to the names, I think you could create two calculated columns as below.

     

    DaysFromToday = DATEDIFF('Table'[date],TODAY(),DAY)


isInLast24hours = IF(DATEDIFF('Table'[date],NOW(),HOUR)<24,"Y","N")

     

    The use the column isInLast24hours as a filter.

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

kunkumuriarjun

 

I have no idea on what your GA dataset is like, according to the names, I think you could create two calculated columns as below.

 

DaysFromToday = DATEDIFF('Table'[date],TODAY(),DAY)


isInLast24hours = IF(DATEDIFF('Table'[date],NOW(),HOUR)<24,"Y","N")

 

The use the column isInLast24hours as a filter.