cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ToFrai Frequent Visitor
Frequent Visitor

Time intelligence - connect tables and use central data slicer not working

Hey folks,

 

quick question to an issue that dirves me mad:

I want to to show the two calculated averages in the two bridge tables, but only use one date slicer from the "date" table.

For Date Column calculation I used the CALENDAR (Min(..) ; Max(...)) function and paired them with the respective date columns (at least in my point of view) correctly.

See the picture below, but unfortunatelly it does not work to set the time span out of which the respective averages should be calculated correctly.

Can you help me please?

Many thanks in advance!Power bi issue time intelligence.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ToFrai Frequent Visitor
Frequent Visitor

Re: Time intelligence - connect tables and use central data slicer not working

Ahh!

Dont know why, but somehow the date formula was buggy.

Put "DATEVALUE(......" in front/ as a frame arround the above mentioned formula and now it works :-)

 

Monday morning starts quite well! ;-)

6 REPLIES 6
ToFrai Frequent Visitor
Frequent Visitor

Time intelligence issue - connect multiple tables and use date slicer from date table

Hey folks,

 

quick question to an issue that dirves me mad:

I want to to show the two calculated averages in the two bridge tables, but only use one date slicer from the "date" table.

For Date Column calculation I used the CALENDAR (Min(..) ; Max(...)) function and paired them with the respective date columns (at least in my point of view) correctly.

See the picture below, but unfortunatelly it does not work to set the time span out of which the respective averages should be calculated correctly.

Can you help me please?

Many thanks in advance!

Super User
Super User

Re: Time intelligence - connect tables and use central data slicer not working

@ToFrai

Does your calendar table have a complete list of dates without any missing dates? If you have missing dates, you will get incorrect or unusable data.

ToFrai Frequent Visitor
Frequent Visitor

Re: Time intelligence - connect tables and use central data slicer not working

Thanks but yes, I think so. I used now "Date = CALENDARAUTO()" which should include every date that would be necessary...

Moderator v-yuezhe-msft
Moderator

Re: Time intelligence - connect tables and use central data slicer not working

@ToFrai,

Could you please share sample data of the above two bridge tables and share DAX you use to create the two average measures? Also please post expected result here.

In addition, do you have datetime values or date values in the above bridge tables?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ToFrai Frequent Visitor
Frequent Visitor

Re: Time intelligence - connect tables and use central data slicer not working

Hi Lydia,

 

Formula to calculate (/copy) the date in the two bridge tables from another one:

Created = Calculate(
   FIRSTNONBLANK('PA Business Partner Survey'[*Created];TRUE());
   FILTER('PA Business Partner Survey';'PA Business Partner Survey'[UUID_Q4] = 'Bridge Q4'[UUID_Q4]))

 

Sample data from the bridge tables:

image.png

 

'think that I use date values then...

 

I expect that I can connect the Date field from the bridge tables with the Date table, create a date slicer in the report based on the Date-Table date with which I can filter the content from the two bridge tables.

 

Hope that helps, thank you for your help in advance.

Tobias

Highlighted
ToFrai Frequent Visitor
Frequent Visitor

Re: Time intelligence - connect tables and use central data slicer not working

Ahh!

Dont know why, but somehow the date formula was buggy.

Put "DATEVALUE(......" in front/ as a frame arround the above mentioned formula and now it works :-)

 

Monday morning starts quite well! ;-)