Forum Discussion

aysultaniya's avatar
aysultaniya
Frequent Visitor
3 years ago
Solved

SAME PERIOD LAST YEAR

 It is urgent please help   I have data till 1st Aug 2023 in an Excel sheet. The remaining sheet is blank below the 1st AUg. Slicer Selection:- 31st July 2023 to 1st August 2023 Date SUM Last Ye...
Need Help
  • some_bih's avatar
    some_bih
    3 years ago

    Hi mickey64 one of best practice to create Date table is on link 

    https://dax.guide/calendarauto/ 

    Limiting dates as in your Step 1 could result in wrong calculation of previous years data.

mickey64's avatar
mickey64
Icon for Super User rankSuper User
3 years ago

I think it may be a bug of Power BI.

 

Step 1: I made a calendar table. [Till 2023/8/2 or Later]

 

Step 2: I made a relationship.

 

Step 3: I made some visuals.

 

  • some_bih's avatar
    some_bih
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi mickey64 one of best practice to create Date table is on link 

    https://dax.guide/calendarauto/ 

    Limiting dates as in your Step 1 could result in wrong calculation of previous years data.

    • aysultaniya's avatar
      aysultaniya
      Frequent Visitor
      3 years ago

      Thank you for your suggestion but I am not able to solve the problem with this . Please provide another solution for that.