Solved: Re: Translate to M

Anonymous · ‎11-04-2020

Could you help transform the following DAX to M please ?

Filter =
IF (
    'Data load check table'[Date]
        = TODAY () - 2,
    2,
    IF ( 'Data load check table'[Date] = TODAY () - 3, 3 )
)

Fowmy · ‎11-04-2020

@Anonymous

Add the following as a Custom Column in Power Query to your table:

if [Date] = Date.AddDays(Date.From(DateTime.FixedLocalNow()),2) then 2 else if [Date] = Date.AddDays(Date.From(DateTime.FixedLocalNow()),-3) then 3 else 0

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

View solution in original post

CNENFRNL · ‎11-04-2020

#"Filter Date" = Table.AddColumn(#"Previous Step", "Filter", each if Source = Date.AddDays(DateTime.Date(DateTime.LocalNow()),-2) then 2 else if Source = Date.AddDays(DateTime.Date(DateTime.LocalNow()),-3) then 3 else null)

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!

Fowmy · ‎11-04-2020