Forum Discussion

Brettacus's avatar
Brettacus
Frequent Visitor
3 years ago
Solved

Multiple If Statements DAX

Hello,   I have been using Power Bi for a few months and I am just starting to get into Dax. Currently I have a report and I only want it to show data for the current quarter plus the previous two ...
Need Help
  • johnyip's avatar
    johnyip
    3 years ago

    Brettacus , please try this measure.

     

     

     

    Last 3 =
var _to=TODAY()
return 
SWITCH(QUARTER(_to),
1,
IF(AND(YEAR(_to)-1=YEAR([DATE]),OR(QUARTER([Date])=4,QUARTER([Date])=3)),1,IF(AND(QUARTER(_to)=QUARTER([Date]),YEAR(_to)=YEAR([Date])),1,0)),

2,
IF(AND(YEAR(_to)-1=YEAR([DATE]),QUARTER([Date])=4),1,IF(AND(OR(QUARTER(_to)=QUARTER([Date]),QUARTER(_to)-1=QUARTER([Date])),YEAR(_to)=YEAR([Date])),1,0)),

IF(AND(YEAR([Date])=YEAR(_to),OR(QUARTER(_to)=QUARTER([Date]),OR(QUARTER(_to)-1=QUARTER([Date]),QUARTER(_to)-2=QUARTER([Date])))),1,0)

)

     

     

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

I am not sure how much i can help but i would like to try.  In the Table/matrix visual, do you want to see Quarters or months in the headers?  Also, share data in a format that can be pasted in an MS Excel file.