Forum Discussion

Tiago_Varela's avatar
Tiago_Varela
Icon for Helper I rankHelper I
7 years ago

IF DAX FORMULA WITH DATE

Hi all, I want ot make a mesure but i can't get it right. I want to say that If today is lower then (criation date) then it should do the formula (rn_total - rn_cancel) if it is after today then it...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Tiago_Varela ,

 

What's type of criation date? Column or measure?

 

If criation date is a column, you should try this.

 

measure =
IF (Max('Table_Name' [criation_data]) < TODAY (), rn_total - rn_cancel, rn_total + rn_cancel )

If you still need help, please share some screenshots to describe your scenario in more details.

 

Best  Regards,

Cherry

Tiago_Varela's avatar
Tiago_Varela
Icon for Helper I rankHelper I
7 years ago

I have a table with the criation date and another with stay dates

Then i have a table with data and measures.

 

I want to say is: for June 2019 i need to know how many rooms i had sell last year for June 2018 at the same criation date last year.

 

So Stay date: june 2019

criation date until today

it gives me the reult for 2019

 

Then i need

stay date last year without changing the dates on my factsheet (so i have "sameperiodlastyea(stay_date)

criation date last year  (sameperiodlastyear(criation_date)

then the formula must have if it is previous to today last year (26/02/2018) it gives me rn_total ; if it is after today last year it gives me rn_total+rn_cancel

 

Sorry i cannot add any screen shot or anything i don't know how i can show you.

 

Thanks a lot for your help

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Tiago_Varela ,

     

    You could copy you data sample which could reproduce your scenario with table format and paste here.

     

    You also could share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)

     

    For image, you should see the Photos button when you reply the post.

     

     

    Best Regards,

    Cherry