Forum Discussion

vsatamraju's avatar
vsatamraju
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
Solved

Default current data update in power bi

Hello Team,   I have three reports and one timeline slicer to set the time frequency. My reports are frequently refreshed i.e twice a day . Now, The problem here is when report got refreshed ,las...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi vsatamraju,

     

    In this scenario, you should be able to use similar formula like below to create a calculate column in your Date table to flag if the date is the latest date, then use the created calculate column "IsLatestDate" as a Slicer with "LatestDate" selected on your report.:smileyhappy:

    IsLatestDate =
IF (
    DateTable[Date] = CALCULATE ( MIN ( DateTable[Date] ), ALL ( DateTable ) ),
    "LatestDate",
    "OtherDates"
)

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi vsatamraju,

 

In this scenario, you should be able to use similar formula like below to create a calculate column in your Date table to flag if the date is the latest date, then use the created calculate column "IsLatestDate" as a Slicer with "LatestDate" selected on your report.:smileyhappy:

IsLatestDate =
IF (
    DateTable[Date] = CALCULATE ( MIN ( DateTable[Date] ), ALL ( DateTable ) ),
    "LatestDate",
    "OtherDates"
)

 

Regards