Power BI - DAY BY DAY SALES GROWTH

  • Share
    Share Video

  • Add
  • More
    Report this video as:
1 0
You have already voted for this video.
TOday we will learn 1. Last MTD comparision with today MTD Value Note: in first step, Don't put table val...
TOday we will learn 1. Last MTD comparision with today MTD Value Note: in first step, Don't put table value column in UI or in table. if u do this then table will be showing blank after that u can put it Last Day order = CALCULATE(SUM('MOM Growth'[Orders]),DATEADD('MOM Growth'[Date],-1,DAY)) Last Day MTD Comarision = var lastdaymtd_compare = EOMONTH(SELECTEDVALUE('MOM Growth'[Date]),-1) return IF(DAY(lastdaymtd_compare)=31,CALCULATE(SUM('MOM Growth'[Orders]),DATEADD('MOM Growth'[Date],-31,DAY)), CALCULATE(SUM('MOM Growth'[Orders]),DATEADD('MOM Growth'[Date],-30,DAY))) 2. History Day value as per day selection or Dynamically change value history first create value table on generate series basies formula Dynamically order history = var orderhistory= "-" & IF(HASONEVALUE('Orderday History'[Order History Day]),VALUES('Orderday History'[Order History Day]),BLANK()) return CALCULATE(SUM('MOM Growth'[Orders]),DATEADD('MOM Growth'[Date],orderhistory,DAY)) Cumulative MTD Day order Cumulative MTD Day Order = CALCULATE(SUM('MOM Growth'[Orders]),DATESMTD('MOM Growth'[Date]) ) Weekday and weekend in measure, text in measure Weekday or weekend = IF(AND(WEEKDAY(SELECTEDVALUE('MOM Growth'[Date]),2)>=1,WEEKDAY(SELECTEDVALUE('MOM Growth'[Date]),2)<=5),"Week Day","Weekend")
Related