Forum Discussion

manishbhamare97's avatar
manishbhamare97
Frequent Visitor
2 years ago

How to refresh the data based on Yesterday's Date

Dear All,   I need your help in order to solve the below issue that I'm facing with Power Bi:   I have the columns in my data for Date, Plan (Count) , Actual (Count). I want it in a table format ...
Need Help
Tips and Tricks
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Show the expected result very clearly.

manishbhamare97's avatar
manishbhamare97
Frequent Visitor
2 years ago

Hi,

 

Below is my expected result:

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    Hi,

    Share the download link of the PBI file.  In that PBi file, have an additional Calendar Table with a column indicating whether the date is a Holiday or not.