Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
5 years ago
Solved

measure help

hi there    i need your support about to create a measure    you can see below rule about that measure    i have date column , the measure must work beased on that column :    if the date col...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

erhan_79 See attached PBIX below sig, Table (18)

Column = 
    VAR __Min = DATE(YEAR(TODAY()),MONTH(TODAY()),1)
    VAR __Max = EOMONTH(__Min,0)
RETURN
    SWITCH(TRUE(),
        [Date]<__Min,"Previous Month",
        [Date]>__Max,"Next Month",
        "Actual Month"
    )
erhan_79's avatar
erhan_79
Post Prodigy
5 years ago

thank you Greg_Deckler  

 

but i want to create a mesure your sample is dax formula 

could you pls help about measure too

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    erhan_79 

    Measure = 
    VAR __Min = DATE(YEAR(TODAY()),MONTH(TODAY()),1)
    VAR __Max = EOMONTH(__Min,0)
RETURN
    SWITCH(TRUE(),
        MAX([Date])<__Min,"Previous Month",
        MAX([Date])>__Max,"Next Month",
        "Actual Month"
    )

    But you can't use a measure in a slicer unless you use the disconnected table trick. In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563 

    • erhan_79's avatar
      erhan_79
      Post Prodigy
      5 years ago

      thank you very much Greg_Deckler 

       

      it is working 

       

      following you from tweeter too 🙂

       

      i wish you success in your business always!you are very helpful