Forum Discussion

toosie's avatar
toosie
Frequent Visitor
3 years ago
Solved

How to get a value based on comparing dates from different tables

I have two tables where the relationship is many to many (the join is Account Number) and I am trying to create a measure doing the following: From table1 - I want to get use the [TimeStamp] field a...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi toosie ,

    The reason why this measure can't be displayed on a monthly/yearly chart is because it is created based on a timestamp, which requires the year, month, and day to appear. You can try to have the timestamp appear on the x-axis instead of the month/year alone.

     

    Or try to create a year/month column?

    Column = var _year=YEAR(Table1[Timestamp])
var _month=MONTH(Table1[Timestamp])
var _1=IF(_month<10,0&_month,_month)
return _year&_1

     

     

    How to get the value to update dynamically when filters are used on the whole page ?

    You can enable the "Auto Refresh" feature in Power BI to update the value dynamically when filters are used on the whole page.

    Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn

     

    Best Regards
    Community Support Team _ Rongtie

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