Forum Discussion

CarelJordaan's avatar
CarelJordaan
Frequent Visitor
3 years ago
Solved

Using measure as calculation on x-axis

I need to show uptake % against [Days From Go-Live], which is a differance between two dates calculation but is given me issues to display on a line diagram. From other forum posts I have seen that ...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    3 years ago

    Hello CarelJordaan ,

     

    So in order to work as x-axis, you need to create the same measure but as a calculated column, thus you'll have numbers to view as days in x-axis.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin
    Vote For my Idea 💡

CarelJordaan's avatar
CarelJordaan
Frequent Visitor
3 years ago

Hi Idrissshatila 

 

Could you please eloborate on the solution?

In which table should this calculated column be created and how what should the DAX expresion look?

I have tried the 2 expressions below but they do not work as one gives a fixed value and the other is not dynamic as it just calculates the difference to the minimum value.

CC-Days From Go-Live = VALUE(MAX('Days_Power BI Data Report'[Date]) - [M-First Install Date])
CC2-Days From Go-Live = DATEDIFF(MIN('Aggregation Zone_Power BI Data Report'[First Installed Order Date Only]),'Days_Power BI Data Report'[Date],DAY)