Great tutorial! Thanks for sharing.

Good one and best explanantion and clearly easily understand the subject .Thanks a lot

@PragmaticWorks

2 жыл бұрын

Glad you enjoyed!

I like your way of teaching! Thank you for that

Thanks for sharing! 👍

Thank you very much, this video really get me into build a fine calendar. easy and fast. Tnx again

@PragmaticWorks

Жыл бұрын

Thanks for watching!

Thanks for sharing! super helpful

Thank you very much for this great video..

Great one! Thanks. How can it be integrated with working days and scheduled holidays if, for example, I want to count only working days between dates? Thanks in advance.

@Jonathon_Silva

2 жыл бұрын

Hi Yuri, there are a few ways we can count the working days between dates - either using M in the Power Query Editor or with DAX and both ways require a bit of work to accomplish. You can email me at jsilva@pragmaticworks.com directly and I can try to get you in the right direction from there if you would like.

Can you show how to add column with weeknumbering in the same formatting style as in Oracle with TO_CHAR('IW') (according to ISO-standard).

Hi, I was trying to mimic what you were doing and got stuck in minute 6:17. I typed exactly the same formula but it shows me the "Token RightParen expected" error. When I click "show error" it highlights 2 letters in a word Number of the second formula "be". Do you have any idea how to fix this?

Hello 👋 maybe you could help me about other topic but related to date as well. Problem : For my End date, I want to get the end of the month (date format) of my previous month as of today end of month local now values. Would this be possible? Example; Today EOM: Feb 28, 2022 Goal Prev EOM: Jan 31, 2022 Hope you can help me resolve this one. Many thanks 😊

Assume final step would be to add the table to the data model?

you are the best

@PragmaticWorks

Жыл бұрын

Thanks for watching!

Thanks. What are differences between creating date table using M code and DAX?

@Jonathon_Silva

2 жыл бұрын

Hi Zula, the major difference between building a calendar or data table using M and DAX is that the M language in the Power Query Editor provides better overall compression for the data model. Typically, we suggest doing as much as possible in the Power Query Editor when building the data model, then you can add to that model, using DAX, where you need to do any additional analysis calculations.

I read this line in the dax manual by Microsoft and I don't get it. they practically mention it for every dax function. "This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules."

@Reventrant

2 жыл бұрын

DirectQuery is fairly limited on the number of transformations you can do with the data.

Your end date is fixed; how do we get the end date to grow? What if I wanted the end date to be 2 weeks after current date?

@Jonathon_Silva

Жыл бұрын

For the end date try the following: Date.AddYears(Date.EndOfYear(DateTime.Date(DateTime.FixedLocalNow())),1) to have a dynamic end period in the calendar. In this case it takes the end date to be one year from the current date.

there is no month 14.....

You’re handsome:)

Very helpful thanks for sharing I always learn power bi from @pragmatic works❤❤