topic Re: DATEADD inside a measure in DAX Commands and Tips

DATEADD inside a measure

Anonymous — Mon, 24 Oct 2022 09:10:01 GMT

Hi everyone,

Trying to create a measure with the help of DATEADD but something is not working.

TEST Orders =

calculate(DISTINCTCOUNT(

'Export'[Id]),

FILTER('Export ','Export'[CaseTyp] = "X"),

FILTER('Export ','Export'[Closed] = "Confirmed"),

FILTER(''Export ','Export'[Status] <> "Pre"),

DATEADD('Export'[DeliveryDate],+30,DAY))

Regards,

Niclas

Re: DATEADD inside a measure

daXtreme — Mon, 24 Oct 2022 09:29:07 GMT

Of course it's not working because you have not taken the effort to get familiar with the time-intel functions and how they work in Power BI. Please head over to http://dax.guide/dateadd and carefully study the documentation. Then, build a correct model (meaning: star-schema).

This measure should work fine after you've understood how the model should be structured:

TEST Orders = CALCULATE( DISTINCTCOUNT( 'Export'[Id] ), KEEPFILTERS( 'Export'[CaseTyp] = "X" ), KEEPFILTERS( 'Export'[Closed] = "Confirmed" ), KEEPFILTERS( 'Export'[Status] <> "Pre" ), DATEADD( 'Calendar'[Date], 30, DAY ) )

Re: DATEADD inside a measure

Anonymous — Mon, 31 Oct 2022 09:21:36 GMT

Hi Anonymous ,

Is your problem solved, if it is solved, you can mark the correct answer, if not, can provide detailed information, we can help you better.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: DATEADD inside a measure

Anonymous — Mon, 14 Nov 2022 13:51:03 GMT

Hi!

Thanks for the help! I will read the documentation. Regarding the star-schema is already in place, just imported a table and wanted to try this first!