Reply
Regular Visitor
Posts: 30
Registered: ‎07-21-2015

Re: SWITCH statement in DAX using a "between this value and this value" as a filter?

A few reference articles for this method in case you are interested.

DAX making the case for switch

The diabolical genius of switch-true


Teal

Regular Visitor
Posts: 16
Registered: ‎05-07-2018

Re: SWITCH statement in DAX using a "between this value and this value" as a filter?

Hi,

 

Does this work with dates? For example:

 

SWITCH(

 

TRUE()

,[SharePointColumnA]="",0

,[SharePointColumnD]="", CALCULATE(SUM(DateTable[WORKDAY], DATESBETWEEN (DateTable[Date], 'SharePointList'[SharePoint ColumnA], Format(TODAY(), "mm/dd/yyyy")

CALCULATE(SUM(DateTable[WORKDAY], DATESBETWEEN (DateTable[Date], 'SharePointList'[SharePoint ColumnA],'SharePointList'[SharePoint ColumnD]))

 

I'm simply trying to find the networkdays/business days between two dates when the end user supplies those two dates. Otherwise, if they don't supply the beginning date which is the SharePoint Column A date, then set the value in that row to 0. and if they only supply an end date, then take the date that was supplied in the beginning date and give me the total value of the business days between that date and today.

Highlighted
Frequent Visitor
Posts: 6
Registered: ‎03-10-2018

Re: SWITCH statement in DAX using a "between this value and this value" as a filter?

This has currently around nineteen million customer and after this click the continue switch. DIRECTV Login Download and install Directv application newest version absolutely free from the web link.