Тёмный

How to use PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR // Beginners Guide to Power BI 

Fernan
Подписаться 50 тыс.
Просмотров 18 тыс.
50% 1

Опубликовано:

 

22 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 23   
@ilmirakerdman1911
@ilmirakerdman1911 2 года назад
Thank you! The best explanation!!!
@jinggao6875
@jinggao6875 2 года назад
Thanks for sharing! What is the formula for Headcount calculation you use, please?
@SolutionsAbroad
@SolutionsAbroad 2 года назад
Hey there, here it is: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0u9yF7lKGW0.html at around 5:00
@matthewshotton86
@matthewshotton86 2 года назад
Great video - do you know how is best to exclude working days from his? I'm current tracking changes daily and get a -100% when using this method
@Unbox747
@Unbox747 9 месяцев назад
Is there a way to build previousmonth in a measure instead of a table you showed? Like this measure will always return the previous month? Don't want to hard code previous month by naming the month either. Want it to be dynamic, is this possible
@Orlandolover01
@Orlandolover01 9 месяцев назад
can you please make a video on retention? rolling 12 months, 90 day, 180 days, 365 days.
@bandaralqahtani4356
@bandaralqahtani4356 2 года назад
amazing like always!! thank you
@SolutionsAbroad
@SolutionsAbroad 2 года назад
You're welcome Bandar, and thanks for watching!
@RS-to6sp
@RS-to6sp 4 месяца назад
how dax to make first month or year is zero (0) exp : when we start in jan24, feb24, mar24 so on the provious month in Jan is 0 (not diff from Dec 23). thank
@shivugv5485
@shivugv5485 Год назад
What is the Headcount measure here without that we cant proceed
@dineshmaurya7884
@dineshmaurya7884 6 месяцев назад
What's the difference between SAMEPERIODLASTYEAR and PREVIOUSYEAR Dax?
@saurabh1812
@saurabh1812 Год назад
Sir thanks Can you tell me difference between dateadd and previousyear
@SolutionsAbroad
@SolutionsAbroad Год назад
Well dateadd allows you to change the intervals like quarters, months, or days, whereas previousyear will only always give you previousyear
@thamilanban
@thamilanban 2 года назад
Thank you
@sandhyaviswanathan9696
@sandhyaviswanathan9696 Год назад
is calendar name of your table that has the date
@SolutionsAbroad
@SolutionsAbroad Год назад
Hi there, yes it is!
@parmeshwarpan3792
@parmeshwarpan3792 Год назад
Please can u share mail id or number i have doubt
@gregday6378
@gregday6378 2 года назад
Hi, great video as always. Any idea why previous quarter might provide a blank value? I have a working current quarter equation... I'm so confused
@wmbp97
@wmbp97 Год назад
Did you ever find a solution? I'm having the same problem.
@adstander5682
@adstander5682 Год назад
Perhaps you will have to add the year as a separate column to the calendar table.
@toluakande6870
@toluakande6870 5 месяцев назад
Thank you,it worked 💃💃😂
Далее
Борщ в стиле высокой кухни!
00:57
Comparing with previous selected time period in DAX
10:23
Compare previous date with sales - Unplugged #52
14:39