cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jozw126 Frequent Visitor
Frequent Visitor

Var month() return multiple columns

Hey, I am trying to calculate a fiscal month using below Var:
Monthtoday= if( month(today())>=7, month(today())-6, month(today()+6).
I am expecting a single value as a result. However, PowerBI said it returns multiple columns.

Could someone please help me understand the issue?

Thank you.
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Var month() return multiple columns

Your code worked for me, but it was missing a single bracket.  Not sure if that was simply a typo when you made this post.  I created a "Measure" and used this:

Monthtoday = if(
    month(today()) >= 7, 
    month(today()) - 6, 
    month(today()) + 6
)

And got this:

Capture.PNG


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


2 REPLIES 2
Super User
Super User

Re: Var month() return multiple columns

Your code worked for me, but it was missing a single bracket.  Not sure if that was simply a typo when you made this post.  I created a "Measure" and used this:

Monthtoday = if(
    month(today()) >= 7, 
    month(today()) - 6, 
    month(today()) + 6
)

And got this:

Capture.PNG


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


Jozw126 Frequent Visitor
Frequent Visitor

Re: Var month() return multiple columns

Thank you for your reply Ross. I used another DAX to get around it before I saw your reply. To be honest, if missing bracket was the cause, Id expect different error message at the beginning.