Forum Discussion

santi17's avatar
santi17
Frequent Visitor
3 years ago

Divide by Date slicer

Hi, I need help with this case.     Stock = Current stock Sold = Sold value will change following the control date. (This one not the problem) -- Average Sales is problem. What I want to...
santi17's avatar
santi17
Frequent Visitor
3 years ago

Hi Grego,

 

Not working well.
It's possible to count value Slincer?

I have try to count range 7/2/2023 tp 7/12/2023 but its count 31..
I use this mesaure:

controldate = COUNTROWS(VALUES(itemLedgerEntries[postingDate].[Day]))

gregoliveira's avatar
gregoliveira
Icon for Helper II rankHelper II
3 years ago

No. You will need to create a calendar table. I believe finishing this measure using the automatic date hierarchy will be very hard.

  • santi17's avatar
    santi17
    Frequent Visitor
    3 years ago

    Thanks Grego..
    So If We can't measure using the automatic date. Can we divide it by the picked value?

     

    I just create "Divide Average" Table

    And inside it only 1 column and with value row 7,10,15 &30