Generateseries is not working with a parameter and single value slicer
I am trying to create a single value slicer I have created a parameter "Target Parameter" and a table "Target" My parameter is "Target Parameter = GENERATESERIES(MIN(Target[Target]),MAX(Target[Target]))" (I have also tried adding the increment of 1 with the same result) the Target Table has 1 column with numbers from 0 to 1048576 generated from a linked excel file. Data type is Decimal Number but I have tried Whole and Fixed as well. When I look at the tables, I don't see any error in the sequenced numbers. When I enter a value such as 100000 into the associated slicer, the number in the slicer automatically changes to 99516 When I enter 2 it is automatically changed to 1 When I enter 1048570 is automatically changed to 1048576 Every number I have tried is changed to a different value except the largest number 1048576 Is there anyway to get it to accept and use the value entered? I intend to use the entered number in other calclations.Unique days in the specified range
Hi Everyone, I have a table as specified in the below screenshot. I'm trying to calculate total unique days in the date range. In this example, expect output is 30 How can we do it in DAX? This calculation needs to happen dynamically and the result will be used in remaining calculations. Hence PowerQuery solution is not suitable.
