Forum Discussion

ArtRijnvicus2's avatar
ArtRijnvicus2
Frequent Visitor
2 years ago

DAX measure: Count from date

good morning all, I have been working in PowerBi for 3 years and have already published several (beautiful) reports in an app. However, now I am faced with the following challenge: I want to count t...
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
2 years ago

Hi ArtRijnvicus2 you wrote details for Alex, but I could not reach that details

ArtRijnvicus2's avatar
ArtRijnvicus2
Frequent Visitor
2 years ago

Does this image work for you?

person 1 joined this data on 01-02-2024 so the measure should count it in februari, march, etc. (but not in januari).

Greetings,

Art

 

 

 

  • some_bih's avatar
    some_bih
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi ArtRijnvicus2 

    For me issue is that you use USERELATIONSHIP, which is ok for non-active relationship. Still, your language is not my native, and not English, so only picture is not usefull.

    What I could notice is that you use in original measure _Dim_Date[Year]), which I "rewrite" to SELECTEDVALUE. If you can not share model, due to sensitivity infos, play a bit with this part _Dim_Date[Year]) and SELECTEDVALUE. 

    • ArtRijnvicus2's avatar
      ArtRijnvicus2
      Frequent Visitor
      2 years ago

      hello Some_Bih,

      iv made a "Community test bpi" file with some made up numbers so i can share it with you. altough i can not share it in a reply. how can i share it with you?

       

      greetings,

      Art

      • some_bih's avatar
        some_bih
        Icon for Community Champion rankCommunity Champion
        2 years ago

        Hi ArtRijnvicus2 if you have Office 365 share link for file or use some other tools (dropbox...)