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 

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