Forum Discussion

JOKA's avatar
JOKA
Icon for Advocate I rankAdvocate I
7 years ago
Solved

Show Full Quarters when I have daily data

Hi!   I´m new to dax and I believe this problem may be very basic but I can´t figure it out. I have a Date table with financial year columns: Financial Year / Quarter  /Month. The financial year st...
Need Help
  • amitchandak's avatar
    amitchandak
    7 years ago

     

    Complete Qtr = if(DATEDIFF(Dates[Date],TODAY(),QUARTER)  >=3,"True","False")

    Create a column like that.

     

    In case you do want show Sep. As it is half, we need to get last month-end date

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
7 years ago

 

Complete Qtr = if(DATEDIFF(Dates[Date],TODAY(),QUARTER)  >=3,"True","False")

Create a column like that.

 

In case you do want show Sep. As it is half, we need to get last month-end date

JOKA's avatar
JOKA
Icon for Advocate I rankAdvocate I
7 years ago

Thank you so much for your help amitchandak !!!

Now it works: