Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Diffrenet tables one Date filter

Hello ,   1. I have a dashboard with two tables ( diffrenet ones with a date filed , EACH DATE FILED NAME IS DIFFRENET) I want to create a filter (Slicer )  that will apply on both tables , for n...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    amitchandak  

    I dont have a date and time colum in my tables , and I prefer not to add columns to my tables(Since I already have a dateeith time column in them)

     

    So instead I used the similare option you guys gave earlier in the thread

    Just instead of using Calander() I created a table as follow(using kusto get data):

     

    let _stepSize = 1m;
    let _offset = 1d;
    let _startTime = startofmonth(now(), -1) - _offset;
    let _endTime = bin(now(), 1m) - _offset;
    range Timestamp from _startTime to _endTime step _stepSize
    | extend Timestamp = Timestamp + _offset
    | extend WeekOffset = toint((startofweek(Timestamp) - startofweek(now())) / 7d)
    | extend Timestamp = Timestamp - _offset
    | order by Timestamp desc
     
     
    and then I added the realations to them and it worked.
    Thanks for helping ,
amitchandak's avatar
amitchandak
Super User
6 years ago

All you tables transaction(Fact) table will have date and time columns and they will join these date and time tables on date and time column. These Date calendar and time table will act as the master table will be used in the analysis.

 

If possible, share pbix file after removing sensitive information.

Like this

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak  

I dont have a date and time colum in my tables , and I prefer not to add columns to my tables(Since I already have a dateeith time column in them)

 

So instead I used the similare option you guys gave earlier in the thread

Just instead of using Calander() I created a table as follow(using kusto get data):

 

let _stepSize = 1m;
let _offset = 1d;
let _startTime = startofmonth(now(), -1) - _offset;
let _endTime = bin(now(), 1m) - _offset;
range Timestamp from _startTime to _endTime step _stepSize
| extend Timestamp = Timestamp + _offset
| extend WeekOffset = toint((startofweek(Timestamp) - startofweek(now())) / 7d)
| extend Timestamp = Timestamp - _offset
| order by Timestamp desc
 
 
and then I added the realations to them and it worked.
Thanks for helping ,
  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    6 years ago

    Anonymous 

     

    Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.