Hope you are doing well and safe!! I have a question regarding Power BI dax. I want to create a dax measure for performance percentage in which numerator and denominator will be as per user filter. Case 1: I want to create a dax measure for performance % (Current Month Sales / Dec'20 Sales) in which current month value will be depending upon user drop down filter and denominator will be fixed with Dec'20 sales value. Case 2: I want to create a dax measure for performance % (Current Month Sales / Previous Month Sales) in which current month value will be depending upon user drop down filter and denominator will be as per previous month depending upon month selection done by user. Thanks in advance :)
Hi. Great Video. I'm working on designing a dashboard in power bi. I want a user click on the slicer by name of project title. For example, the user click project A in the slicer. As a result, the graph will show that project A's progress for all months (Jan-Dec). Otherwise, if the user is not clicking the slicer, the graph remains blank. how I'm supposed to do? Thank you.
Hi, I have a same kind of process but I have created a new table using dax based on selectedvalue from slicer. I am just filtering date and selectcolumns. But when tried filter using selectedvalue i am getting error like "do not compare values text with integer, try use Format of any value". Could you please help me out
Loved this explanation. It makes me easy to understand selectedvalue Dax
My pleasure
Awesome explanation, thanks
My pleasure
Thanks for sharing, very helpful
Thank you.
Hope you are doing well and safe!!
I have a question regarding Power BI dax. I want to create a dax measure for performance percentage in which numerator and denominator will be as per user filter.
Case 1: I want to create a dax measure for performance % (Current Month Sales / Dec'20 Sales) in which current month value will be depending upon user drop down filter and denominator will be fixed with Dec'20 sales value.
Case 2: I want to create a dax measure for performance % (Current Month Sales / Previous Month Sales) in which current month value will be depending upon user drop down filter and denominator will be as per previous month depending upon month selection done by user.
Thanks in advance :)
Hi many thanks 🙏.. can we connect need private training on power bi
Hi. Great Video.
I'm working on designing a dashboard in power bi. I want a user click on the slicer by name of project title.
For example, the user click project A in the slicer. As a result, the graph will show that project A's progress for all months (Jan-Dec). Otherwise, if the user is not clicking the slicer, the graph remains blank. how I'm supposed to do?
Thank you.
How do you pick up and display values of slicers that have to and from date or currency slicer values.
Hi,
I have a same kind of process but I have created a new table using dax based on selectedvalue from slicer.
I am just filtering date and selectcolumns. But when tried filter using selectedvalue i am getting error like "do not compare values text with integer, try use Format of any value".
Could you please help me out
{FIXED[AUDIT] : MAX(if YEAR([SCHDL]) = year (today() )THEN [MIN_AUDIT] END } can you explain how to solve this Tableau function into Power BI DAX??