Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
hello,
i'm trying to automate the following code in M
= Table.SelectRows(#"Changed Type2", each [DateEoM] <= "2021-06-30")
with [DateEoM] a date table which has all end of moth date
what i want to do is a variable with take automatically the EOM date instead of me writing it like i did here "2021-06-30"
sommeone knows how to do it please ?
Solved! Go to Solution.
Date.EndOfMonth(dateTime as any)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Date.EndOfMonth(dateTime as any)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |