Forum Discussion

ToFrai's avatar
ToFrai
Frequent Visitor
8 years ago
Solved

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 Co...
  • ToFrai's avatar
    ToFrai
    8 years ago

    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! ;-)

ToFrai's avatar
ToFrai
Frequent Visitor
8 years ago

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:

 

'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

ToFrai's avatar
ToFrai
Frequent Visitor
8 years ago

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! ;-)