Forum Discussion

vijay273162's avatar
vijay273162
Helper III
4 years ago

SAMEPERIODLASTYEAR based on Running Days

Hi All, Refer the below Simplified example.     So, I need to go back to PREVIOUS YEAR SAME QUARTER and based on Running day number, need to get the Total Sales value.   If I use SAME PER...
Need Help
Show and Tell
Tips and Tricks
vijay273162's avatar
vijay273162
Helper III
4 years ago

HI Amit,

 

Not to compare Weekday of CY with Weekday of PY.

But, to compare, Running days no. of Current year with Running Day no. of Previous year.

 

Running Day no. is calculated as you said earlier using DAX CODE.

 

DESC - Running days_Quarter_(Excl_Wknd) =
COUNTROWS(
FILTER(
ADDCOLUMNS(CALENDAR(Period[Date],Period[End date of Quarter]),
"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),
[WorkDay] =1)
)
)
 
So, it will exlcude Weekends while counting running days in Quarter.
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi vijay273162 ,

     

    I can see "PY" and "CY" in your screenshot, are they from same table or from two different tables. I know they have the same format. If they are from two tables, I suggest you to combine them into one table in Power Query Editor.

    For reference: Append queries

    Could you share a sample file with me and show me the result you want? This will make it easier for me to find the solution.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.