cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Dax Formula Help

Hi there ;

 

İ just want to create a new formula but i can nat create because i am very new at DAX .

 

Coluld you pls help me about below issue , thanks for your supports.

 

Issue : 

 

I have one column with dates as below.İ want to see that , if the date column's date is after this month ( the month that we are in)  , it will write to  near cell "true" in number column.İf not  the cell will be empty in new column.

 

İ want like that : 

Capture.JPG

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver III
Resolver III

Re: Dax Formula Help

Hi,

Just add a calculated column and use that DAX formula : 

Number =
IF(AND(MONTH(Table1[Date])>MONTH(NOW()),YEAR(Table1[Date])>=YEAR(NOW())),"TRUE",BLANK())

 

1.PNG

View solution in original post

2 REPLIES 2
Highlighted
Resolver III
Resolver III

Re: Dax Formula Help

Hi,

Just add a calculated column and use that DAX formula : 

Number =
IF(AND(MONTH(Table1[Date])>MONTH(NOW()),YEAR(Table1[Date])>=YEAR(NOW())),"TRUE",BLANK())

 

1.PNG

View solution in original post

Highlighted
Helper II
Helper II

Re: Dax Formula Help

Hi drors ; 

 

I am very glad to see your reply , and it is working .

 

Thank you very much for support.

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors