cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sowmiya Regular Visitor
Regular Visitor

Dax for YTD,QTD,WTD,DTD, Half Year

Hi Community,

 

Need DAX for YTD, MTD, QTD, WTD, DTD, Half Year in single slicer visual. Here In my case I'm having date field in which slicing measure to be calculated.

 

Thanks In Advance,

Regards,

Sowmiya

4 REPLIES 4
Super User
Super User

Re: Dax for YTD,QTD,WTD,DTD, Half Year

Hi @Sowmiya

 

Can you share some sample data and solution you expect. How many slicers are you going to have ? A single slicer which has options for YTD, MTD, QTD,WTD,DTD, Half -Year ???

 

 

Cheers

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
themistoklis New Contributor
New Contributor

Re: Dax for YTD,QTD,WTD,DTD, Half Year

@Sowmiya

 

You cant create slicers from measures (calculated fields)

Community Support Team
Community Support Team

Re: Dax for YTD,QTD,WTD,DTD, Half Year

Hi @Sowmiya,

Based on my research, I am afraid you could not use measures as slicer, but you could refer to using bookmarks and buttons to show your visual in differnt Scenes:

Reference:http://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

 

 

Regards,

Daniel He

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Sowmiya Regular Visitor
Regular Visitor

Re: Dax for YTD,QTD,WTD,DTD, Half Year

Hi @CheenuSing

Yes, I need single slicer for YTD,QTD,WTD,DTD, Half Year.  

Following are my datasetsSlide2.jpg

I need function for following slicer format

 

2.1.png

Thanks In Advance