Forum Discussion
Resolver IICalendar question
Hi gco ,
Here is the input form for the conditional column.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Community ChampionCommunity ChampionHi gco
Doing this in Power Query is more efficient. Matches your post.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
= Table.AddColumn(#"Changed Type1", "CurrentDate", each if Date.Month([#"Dates IsCurrentorPastMonth?.1"]) <= Date.Month(DateTime.LocalNow()) then "Y" else "N")
- Nathaniel_C
Just tried it with 10/31 and it works. Good point.
- Nathaniel_C
Hi gco ,
Here is the input form for the conditional column.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
gco
- gco
hey Nathaniel_C ,
That is pretty quick. I am pretty noob. can you please tell me how to do this? i am used to right-clicking an existing table and then entering the DAX.