topic Re: CalculationGroups - switch between dates in DAX Commands and Tips

CalculationGroups - switch between dates

Fragmaticx — Wed, 27 Aug 2025 10:38:57 GMT

Hi

I have a model where I use calculaton groups to switch between dates.

Lets say its a Order Date and Delivery Date - and I want to make a calculation based of the 2 dates.

I think i need something like, if selectedmeasure is OperationalDate then

BaseData[ShipmentPeriod] <> BaseData[OperationalPeriod]
elseif

Selectedmeasure is ShipmentPeriod then

BaseData[OperationalPeriod] <> BaseData[ShipmentPeriod]

Lastmile Cost - Different Period = CALCULATE( SUMX(BaseData, BaseData[AmountDKK]), FILTER( BaseData, BaseData[Type] = 2 && BaseData[TransportType] = 1 && BaseData[ShipmentPeriod] <> BaseData[OperationalPeriod] ) )

but I dont know how to do it?

Re: CalculationGroups - switch between dates

FBergamaschi — Wed, 27 Aug 2025 10:45:00 GMT

I am unsure as to what you are trying to do

Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.

Need help uploading data? click here

Want faster answers? click here

Re: CalculationGroups - switch between dates

techies — Wed, 27 Aug 2025 20:27:19 GMT

Hi Fragmaticx As i understand, you can try using ISSELECTEDMEASURE where you want change depending on measures shipment based, operational based

Please share sample datasets to test

Re: CalculationGroups - switch between dates

Fragmaticx — Thu, 28 Aug 2025 05:31:42 GMT

Hi everybody,

This is a small sample set.

I have a calculation group: DateToUse
Item 1:

SELECTEDMEASURE ()

Item 2:

CALCULATE ( SELECTEDMEASURE (), USERELATIONSHIP ( BaseData[ShipmentPeriod], 'DateTable'[Date] ) )

OperationalPeriod	ShipmentPeriod	AmountDKK	Type	Customer	TransportType
01-08-2025	01-08-2025	100	2	Dennis	1
01-07-2025	01-08-2025	150	2	Dennis	1

Lastmile Cost - Different Period = CALCULATE( SUMX( BaseData, BaseData[AmountDKK] ), FILTER( BaseData, BaseData[Type] = 2 && BaseData[TransportType] = 1 && BaseData[ShipmentPeriod] <> BaseData[OperationalPeriod] ) )

I expect it to show if ShipmentPeriod is selected then it should be 0 since both lines are within that period, and if OperationalPeriod is selected it should show 150, since they are 01-07-2025.

I appriciate your help,

Re: CalculationGroups - switch between dates

techies — Thu, 28 Aug 2025 08:31:52 GMT

Hi Fragmaticx please try this

Lastmile Cost - Different Period =

VAR CurrentCalcItem = SELECTEDVALUE ( 'DateToUse'[Calculation group column] )

RETURN

CALCULATE (

SUM ( BaseData[AmountDKK] ),

BaseData[Type] = 2,

BaseData[TransportType] = 1,

SWITCH (

CurrentCalcItem,

"OperationalPeriod", BaseData[ShipmentPeriod] <> BaseData[OperationalPeriod],

"ShipmentPeriod", BaseData[OperationalPeriod] <> BaseData[ShipmentPeriod]

)

Re: CalculationGroups - switch between dates

v-hashadapu — Mon, 01 Sep 2025 09:56:50 GMT

Hi Fragmaticx , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.

Re: CalculationGroups - switch between dates

v-hashadapu — Fri, 05 Sep 2025 11:05:33 GMT

Hi Fragmaticx , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.

Re: CalculationGroups - switch between dates

v-hashadapu — Tue, 09 Sep 2025 05:52:50 GMT

Hi Fragmaticx , Thank you for reaching out to the Microsoft Community Forum.

We find the answer shared by techies is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.
Thank you techies for your valuable response.