Need Help with DAX function to populate Date_Time field while choosing parameter

[jagtapsangha]

Hi ,

I want to populate a values(Date) in "Date_Time" column, while applying a 'Choose_Type' parameter in the slicer inside the report

Example -
1)If I select "BBB" then it should populate values from "Query_Date" Field in Date_Time Column
and
2)If I select "CCC" then it should populate values from "QC_

 

Date" Field in Date_Time Column

We are using 'Choose_type' parameter because it is dependent parameter for of data

Close_Date	Query_Date	QC_Date	ProjectName
9/19/2022			A
9/18/2022	8/17/2022		B
9/17/2022		8/17/2022	C
9/16/2022		8/17/2022	D
9/15/2022	8/17/2022		E
9/14/2022	8/17/2022		F

I have attached the dummy file. Does anyone has solution for above mention scenario.

[v-yadongf-msft · Accepted solution]

Hi @jagtapsangha ,

Please consider using field parameters.

1.Create three measures:

AAA = SELECTEDVALUE('Table'[Close_Date])
BBB = SELECTEDVALUE('Table'[Query_Date])
CCC = SELECTEDVALUE('Table'[QC_Date])

2. Using field parameters.

3.After creating a field parameter, you will get a parameter slicer automatically.

4.Create a table visual like this:

5. The result you want:

Best regards,

Yadong Fang

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

[jagtapsangha]

[Greg_Deckler]

@jagtapsangha You can't do that as a calculated column because those are not dynamic and are calculated at the time of data refresh/load. You could do it as a measure.

[jagtapsangha]

Hi @Greg_Deckler , 

We want to use this "Date_Time" Column as a filter in Slicer so cant do that with Measure , so is their any other work around or option to solve this?

Thanks

[Greg_Deckler]

@jagtapsangha Potentially unpivot your two date columns?

[jagtapsangha]

Many other fileds are depend on My "Choose_Type" parameter , 

by using that filter on parameter we wanted to calculate further  fields 

you can check the snapshot attached