Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hi ,
i have used my own calendar with manually , And there will be some day on 23rd Jan go to February alr.
and there will be another day to go for the whole year.
Once i import it , i have used calculation of Total Last Month and Last Week , but the result turns weird and i failed to understand. seems like it doesn't follow my own manual calendar.
Below link is the Calendar i have created , Can you please try it and get back to me if i did sth wrong or you have another way to make it right ?
https://www.dropbox.com/s/kjagnqr6q2jk4ef/445%20Calendar.xls%20new.xlsx?dl=0
This is the calculation i have used and it turns weird result.
When you use date table,please make sure you've linked the sample data table and date table.Then use date table's date column as dimension.If you need further help,please share a simplified sample file for us to test.You can upload the .pbix file to OneDrive and post the link here.
Regards,
hi @v-cherch-msft ,
kindlly find the link below :
https://www.dropbox.com/s/vi4olrwmkpo9qjh/Testing%20Cooler.xlsx?dl=0
Hi , Can you help me to do Total Last Month and Total Last Week of Coolers or Fountain ?
through my 445 Calendars i shared ?
Thanks with Regards,
Chanleakna Hang
Please check if below posts could help you.
https://community.powerbi.com/t5/Desktop/Variance-between-two-measures/m-p/588970#M279325
Regards,
@v-cherch-msft hi dear , i have searched around and failed to get the result even the link you sent is not my expectation. Can you please assist to the sample one for me as the table i shared in Dropbox ?
Thx
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |