Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
80 | |
67 |