Forum Discussion
Solved
Help Needed in Writing a Calculation
My requirement is keeping ID as Fixed find the value when the Temp is between 0 and 32. I have written a calculation in tableau and would like to wirte the same calculation in DAX. Kindly help me ...
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new table.
New Table = FILTER ( Data, Data[Temp] >= 0 && Data[Temp] <= 32 )jananagarajan You can achieve this through visual or page-level filters.
In the below image, I have applied a visual level filter on the Temp field. Hope this helps.For fun only, a showcase of powerful Excel worksheet formula,
T-SQL solution,
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new table.
New Table =
FILTER ( Data, Data[Temp] >= 0 && Data[Temp] <= 32 )